Search found 143 matches

by arrbee
Thu Oct 08, 2009 8:30 pm
Forum: EASYTRIEVE
Topic: compiling options
Replies: 3
Views: 6934

example

Hi,

Can you please help me with a code example?

Thanks.
by arrbee
Thu Sep 24, 2009 9:23 am
Forum: EASYTRIEVE
Topic: compiling options
Replies: 3
Views: 6934

compiling options

Hi, How to code compiling options in an EZYTRIEVE program like we do in a COBOL program?

Examples would help me a lot.

Thanks.
by arrbee
Tue Sep 22, 2009 2:23 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: a Sub-Query and a Correlated Sub-Query
Replies: 3
Views: 5761

inner query?

Hi, Thanks for the reply.

Does inner query execute first or outer query in sub-query / correlated sub-query?

Please explain.

Thanks.
by arrbee
Sat Sep 12, 2009 9:38 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: a Sub-Query and a Correlated Sub-Query
Replies: 3
Views: 5761

a Sub-Query and a Correlated Sub-Query

Hi,

Would you please tell me how a sub-query looks like and a correlated sub-query? Do they always have fixed form of writing it?

Thanks.
by arrbee
Thu Feb 05, 2009 6:28 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: DFSORT
Replies: 2
Views: 2905

How about few sample records and expected output?

Thx.
by arrbee
Fri Jan 30, 2009 7:46 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: to merge 2 records of the input file using SORT
Replies: 18
Views: 21685

Hi,

What is the RECFM & LRECL of your file?

Thanks.
by arrbee
Fri Jan 30, 2009 4:33 pm
Forum: FILE-AID
Topic: COPYBACK fails with MAXCC=8 !
Replies: 0
Views: 3640

COPYBACK fails with MAXCC=8 !

Hi, I am trying below job but fails with MAXCC=8. //STEP0004 EXEC PGM=FILEAID //SYSPRINT DD SYSOUT=* //SYSOUT DD SYSOUT=* //DD01 DD * BAMA1 BAMA2 BAMA3 BAMA4 BAMA5 BAMA6 //DD01O DD SYSOUT=* //SYSIN DD * $$DD01 COPYBACK OUT=1 END //* What is wrong with this JCL? Please help. Thanks.
by arrbee
Thu Jan 29, 2009 9:36 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: ALTSEQ statement
Replies: 8
Views: 9164

Frank, how to apply this logic to replace null values instead of spaces?

Thanks.
by arrbee
Thu Jan 29, 2009 9:33 pm
Forum: FILE-AID
Topic: continuation character in File-Aid batch.
Replies: 2
Views: 7149

Anuj, would you please help me with this?

Thanks.
by arrbee
Thu Jan 29, 2009 9:27 pm
Forum: FILE-AID
Topic: NOT Condition.
Replies: 7
Views: 12964

Veera, thanks for the idea.

Anuj, I have a big file to search. There are only 4 to 5 records in that file I want to capture. So, I was trying it with NE.

Thanks.
by arrbee
Thu Jan 29, 2009 7:28 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Copy matching records from 2nd file.
Replies: 5
Views: 6831

Frank, Thank you very much. It helped a lot. :D
by arrbee
Wed Jan 28, 2009 9:40 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Copy matching records from 2nd file.
Replies: 5
Views: 6831

Frank, Thanks. I will try it out and let you know.
by arrbee
Wed Jan 28, 2009 1:52 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Copy matching records from 2nd file.
Replies: 5
Views: 6831

Reply - Here are the details

Frank, Thanks for the reply. Here are the details........ 1). File-A is the 1st file and File-B is the 2nd file. 2). All the output files will have RECFM=FB and LRECL=160. 3). The outputs appear as given below: Output-1: 000 BSS0000000000000001234512009 FLA000A 000 BST0000000001000001234562009 FLS00...
by arrbee
Tue Jan 27, 2009 9:24 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Copy matching records from 2nd file.
Replies: 5
Views: 6831

Copy matching records from 2nd file.

Hi, I have one file that appears as given below. It's RECFM=FB & LRECL=80. The key field here starts at 24th column and it's of 6 bytes. ----+----1----+----2----+----3----+----4----+----5 000001371044800001000001234564800000FLAGP 000001718271300001000001234571300000FLAGP 0000014379716000010000012345...
by arrbee
Tue Sep 23, 2008 5:38 pm
Forum: FILE-AID
Topic: NOT Condition.
Replies: 7
Views: 12964

NOT Condition.

Hi, How to use the NOT condition to search entire PS using File-Aid? Generally, we give it like........ //SYSIN DD * $$DD01 COPY IF=(1,0,C'FILEAID') /* I tried the below and it did not work..... :( //SYSIN DD * $$DD01 COPY IF=(1,80,NE,C'FILEAID') /* Any thoughts? Please help. Thanks.