It would be helpful to have a sample of the .CSV input and the problem you need to overcome. Having a variable number of fields is should not be a problem
Stan
Two methods
#1 FTP
Ftp to MVS, cd to the PDS and use "mget *" to download all members
#2 JCL
Write 2 steps JCL using PGM=IEBPTCH to punch out the PDS members then use FTPPROC, or whatever the name at our site, to FTP to the server
Stan Mlynarski
#1 problem I see is the syntax for writing. I use
"EXECIO * DISKR indd (STEM REC. FINIS)"
where "REC." is the stem variable that holds all the data to be written.
#2 problem I do not see where the member name in the PDS is.
I have a REXX program that creates and submits JCL to do the compile; contact me to have it Emailed.
Most importantantly to get files out of ELIPS Librarian is to have SUBSYS=LAM on the DD statements.
stanley.mlynarski@ACS-inc.com
I agree with KiwiRexxdude, since I have also come across this messagae in MVS and PC DOS. You should free/close files after using them. You may want to try writing a program that keeps opeing files and display the number to demonstrate at what point the message comes up. Then you'll know the limit.
I helped a friend do something similar and it wasn't possible to do both UNIX script and telnet together. However, why not write a script on the target machine to
(1) tail log >file
(2) ftp to your machine and put the file there .
Also, why not ftp the file to your machine and tail the local file
I had to extract data that MAY be across 3 tables. I got rid of the unneeded code
so it may look choppy but the pricipal is here
SELECT A.ISBN, CATALOG_PRICE, FPT_COVER_PRICE
FROM table1 A, table2 B, table3 C
WHERE TITLE_STATUS_CODE NOT IN ('AFS', 'NOP') etc. etc.
UNION ALL...
Soln #1 Not a solid answer but you might look into exit routines to format this.
I know IBM MVS has this capability
Soln #2 Pass the report to a file and have a post process program parse it properly
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.