Search found 12 matches

by mgypraveen
Wed Aug 19, 2009 5:27 pm
Forum: JCL
Topic: JCL-I need to FTP from MF to Local computer
Replies: 6
Views: 15406

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
by mgypraveen
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
by mgypraveen
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...
by mgypraveen
Tue Oct 14, 2008 7:27 pm
Forum: JCL
Topic: JCL- Filter Large data for small Number based on Condition
Replies: 19
Views: 35293

If Fiel x and File Y are DSN File. Cannot be listed there as it is listed above then can I use DD statement
Like
//FILEX DD * DSN=USER.FILEX,DISP=SHR

Pelase let me know
Thanks
by mgypraveen
Tue Oct 14, 2008 4:49 pm
Forum: JCL
Topic: JCL- Filter Large data for small Number based on Condition
Replies: 19
Views: 35293

Sir any Help on this!!!
Please ...

Thanks!!
Hope i ma not taking too much of your time..by extendignmy question.
by mgypraveen
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...
by mgypraveen
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...
by mgypraveen
Tue Oct 14, 2008 4:06 pm
Forum: JCL
Topic: JCL- Filter Large data for small Number based on Condition
Replies: 19
Views: 35293

Additon information is

Input file - 'X' databaset - contains 1000 records

the list of 50 city is another dataset "Y".

I need ony those record form "X" where "X" and "Y" matches by City variable
by mgypraveen
Tue Oct 14, 2008 4:04 pm
Forum: JCL
Topic: JCL- Filter Large data for small Number based on Condition
Replies: 19
Views: 35293

Your UNderstandign is correct.
Please let me know the Syntax if possible. on how to use.
by mgypraveen
Tue Oct 14, 2008 3:17 pm
Forum: JCL
Topic: JCL- Filter Large data for small Number based on Condition
Replies: 19
Views: 35293

I have limited or Now knowledge of either of the Procedures.

So any of the best method to Filter to read will help.

IF woudl be Great if you cna share with the Syntax in DD statement.
by mgypraveen
Tue Oct 14, 2008 1:19 pm
Forum: JCL
Topic: JCL- Filter Large data for small Number based on Condition
Replies: 19
Views: 35293

It contains Records.
by mgypraveen
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.