Belwo script I use to download
ATTRALL.csv file form Guts to Abacus.
then We use Ftp window to Download...
open iri1
user <ID> <PWD>
ASCII
get 'XXXXX.DICT.ATTRALL' /XXX/xxxx/ATTRALL.csv
close
quit
Search found 12 matches
- Wed Aug 19, 2009 5:27 pm
- Forum: JCL
- Topic: JCL-I need to FTP from MF to Local computer
- Replies: 6
- Views: 15406
- Wed Aug 19, 2009 5:09 pm
- Forum: JCL
- Topic: JCL-I need to FTP from MF to Local computer
- Replies: 6
- Views: 15406
JCL-I need to FTP from MF to Local computer
I need to FTP a CSV/.txt file from the Maniframe to Local machine.
I DONT want to FTP to Abacus then to Local machine But I need directly to loacla machine.
It will be great if some one has a tested script that I can use.
Thanks
Praveen
I DONT want to FTP to Abacus then to Local machine But I need directly to loacla machine.
It will be great if some one has a tested script that I can use.
Thanks
Praveen
- Wed Oct 15, 2008 5:15 pm
- Forum: JCL
- Topic: JCL- Filter Large data for small Number based on Condition
- Replies: 19
- Views: 35293
Error!
I would like to ask, for ICETOOL are the option listed by you useed are default? will they present in every installment. I am using IBM mainframe. //icetool JOB (DRALD,TEST),'SORT JCL',CLASS=S,REGION=0M, // MSGCLASS=T,NOTIFY=&SYSUID //S1 EXEC PGM=SYNCTOOL //TOOLMSG DD SYSOUT=* //DFSMSG DD SYSOUT=* S...
- Tue Oct 14, 2008 7:27 pm
- Forum: JCL
- Topic: JCL- Filter Large data for small Number based on Condition
- Replies: 19
- Views: 35293
- Tue Oct 14, 2008 4:49 pm
- Forum: JCL
- Topic: JCL- Filter Large data for small Number based on Condition
- Replies: 19
- Views: 35293
- Tue Oct 14, 2008 4:33 pm
- Forum: JCL
- Topic: JCL- Filter Large data for small Number based on Condition
- Replies: 19
- Views: 35293
Hi, Also it will be greta if you can tell me if I need to Filter "X" not jsut by one variable but by 2 variables ( City and street) of "Y" data set. then How Can i perform. data X is City Street HH age NY abc 3 45 NY abc 1 18 PY abc 4 60 XY abc 5 30 NY abc 7 35 NY xyz 9 50 NY xyz 3 22 ... ... ( mill...
- Tue Oct 14, 2008 4:21 pm
- Forum: JCL
- Topic: JCL- Filter Large data for small Number based on Condition
- Replies: 19
- Views: 35293
Hi, Unfortunately we cannot list all those 50 Right.. it will be huge... INCLUDE COND= command. It was jsut an example of 1000 (X) records and 50 (Y) records. If it si in millions in X and need to filer for 100000's then we cannot list all of them in synatx 'INCLUDE COND=". is there a different meth...
- Tue Oct 14, 2008 4:06 pm
- Forum: JCL
- Topic: JCL- Filter Large data for small Number based on Condition
- Replies: 19
- Views: 35293
- Tue Oct 14, 2008 4:04 pm
- Forum: JCL
- Topic: JCL- Filter Large data for small Number based on Condition
- Replies: 19
- Views: 35293
- Tue Oct 14, 2008 3:17 pm
- Forum: JCL
- Topic: JCL- Filter Large data for small Number based on Condition
- Replies: 19
- Views: 35293
- Tue Oct 14, 2008 1:19 pm
- Forum: JCL
- Topic: JCL- Filter Large data for small Number based on Condition
- Replies: 19
- Views: 35293
- Tue Oct 14, 2008 12:31 pm
- Forum: JCL
- Topic: JCL- Filter Large data for small Number based on Condition
- Replies: 19
- Views: 35293
JCL- Filter Large data for small Number based on Condition
I have a dataset "X" which has 1000 Citys Dasets. I need to read the data set for only 50 City data. I have the list of those 50 City. How do I filter at DD statement while reading the data in JCL.