 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 8 matches |
| Author | Message |
|---|---|
 Topic: sql code -518 as the string contains quotes |
|
| Dummy Replies: 3 Views: 2977 |
 Forum: Database Posted: Tue Aug 02, 2005 1:30 pm Subject: sql code -518 as the string contains quotes |
| Can you try using two continous single quotes instead of one? This works (considered as one quote) in few places.
Are you using a place holder or Iteral value? |
|
| Topic: Create one record. Input from two files. SYNCSORT |
|
| Dummy Replies: 9 Views: 14089 |
Forum: Utilities Posted: Thu Mar 10, 2005 6:37 pm Subject: Create one record. Input from two files. SYNCSORT |
| Thanks Kolusu,
In the output I had posted, there will be one record from the inputA and one or more records from InputB for the same first 10 bytes. But in my final output first 10 bytes are not ... |
|
| Topic: Create one record. Input from two files. SYNCSORT |
|
| Dummy Replies: 9 Views: 14089 |
Forum: Utilities Posted: Mon Mar 07, 2005 12:53 pm Subject: Create one record. Input from two files. SYNCSORT |
| Thanks Kolusu.
Cool, the code generates sort control cards but am doubtful if it will be appilicable in my case. My bad, I thought of giving a simple version then transfer it to my real need. Le ... |
|
| Topic: Report Printing |
|
| Dummy Replies: 16 Views: 8142 |
Forum: Utilities Posted: Fri Mar 04, 2005 1:00 pm Subject: Report Printing |
| If you have Synsort you can access DB2 Tables.
Try this, if it does not work try talking talking to your system programmers in your shop. //SQLINSRT EXEC PGM=SORT, // PARM='DB2=SUBS' ... |
|
| Topic: Is this possible with DFSORT? |
|
| Dummy Replies: 3 Views: 2065 |
Forum: Utilities Posted: Fri Mar 04, 2005 12:46 pm Subject: Is this possible with DFSORT? |
| This might be possible depending on our input.
Is the Address always 4 lines? Will it be alternate addresses like 1,3, 5 & 7 records will be company-1. 2,4,6 & 8 will be company-2? |
|
| Topic: Create one record. Input from two files. SYNCSORT |
|
| Dummy Replies: 9 Views: 14089 |
Forum: Utilities Posted: Fri Mar 04, 2005 12:33 pm Subject: Create one record. Input from two files. SYNCSORT |
| Its quite sometime since I used SORT. I have two files Input-A and Input-B. Need to create a Output file. There's a common field which needs to be used to join these two files.
This common field i ... |
|
| Topic: IPCPBTCH |
|
| Dummy Replies: 1 Views: 4418 |
Forum: CICS and Middleware Posted: Wed Aug 13, 2003 1:41 am Subject: IPCPBTCH |
| That utility is used to OPEN/CLOSE online files, from batch. You can watch in your CICS region(s) for IPCP task running. Also you can initiate transaction from CICS. This comes from SDS. Am not sure w ... | |
| Topic: How to trap the PF key that was entered on the ISPF screen |
|
| Dummy Replies: 19 Views: 22175 |
Forum: TSO and ISPF Posted: Fri Jan 17, 2003 7:19 am Subject: How to trap the PF key that was entered on the ISPF screen |
| Hi Anand,
Try adding "ispexec vget (zpfkey ) " in the WHILE loop |
|
All times are GMT - 5 Hours |