Search found 31 matches
- Fri Oct 23, 2009 11:49 am
- Forum: XML
- Topic: Cobol XML conversion
- Replies: 3
- Views: 10183
Hi, You will get full details from the below site http://publib.boulder.ibm.com/infocenter/iadthelp/v7r0/index.jsp?topic=/com.ibm.etools.iseries.langref.doc/c0925395576.htm http://publib.boulder.ibm.com/infocenter/comphelp/v101v121/index.jsp?topic=/com.ibm.aix.cbl.doc/PGandLR/ref/rllanxew.htm pdf --...
- Wed Oct 08, 2008 10:34 am
- Forum: JCL
- Topic: Sending an Email from JCL with attachment
- Replies: 36
- Views: 107814
This can be done using the below SAS program. //MAILJCLX JOB (DEVLD,TEST),'MAILJCLX TEST',CLASS=X,MSGCLASS=X,NOTIFY=&SYSUID //STEP0 EXEC SAS //REPORT1 DD DSN=DVAN.MFDATASET.TEST,DISP=SHR //SYSIN DD * %LET MAILFILE = %SYSFUNC(PATHNAME(REPORT1)); DATA _NULL_; CALL SYMPUT(?FDATE?, LEFT(PUT(?&SYSDATE?D-...
- Wed Dec 13, 2006 1:11 pm
- Forum: EASYTRIEVE
- Topic: Usage of THRESHOLD parameter in Easytrieve DATE MACROS
- Replies: 1
- Views: 8298
Usage of THRESHOLD parameter in Easytrieve DATE MACROS
Importance of THRESHOLD parameter in DATECONV MACRO: The DATECONV routine converts a date-in-one format to any other date format. %DATECONV date1 format1 date2 format2 [THRESHOLD value] [THRESHOLD value] This optional parameter establishes the upper end of a 100-year range in the 20th and 21st cent...
- Thu Nov 16, 2006 12:00 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Deleting large numbers of rows quickly
- Replies: 1
- Views: 8237
Hi, Partitioning strategy is good for that case. In DB2, we can truncate partition alone. No need to drop the partition and add it again. alter table table_name truncate partition partition_name; Look whether this can be done in UDB as well. There is no disadvantages because of partitioning apart of...
- Wed Nov 15, 2006 5:46 pm
- Forum: JCL
- Topic: test datase empty
- Replies: 8
- Views: 31686
Hi, You can get this using ICETOOL or FILEAID or IDCAMS.... Using IDCAMS here is the solution //STEP01 EXEC PGM=IDCAMS //IN DD DSN=DATASET <--- Dataset to be checked //SYSPRINT DD SYSOUT=* //SYSIN DD DATA PRINT INFILE(IN) COUNT(1) /* This will give RC=0 if file has at least 1 record, otherwise RC=4....
- Tue Nov 07, 2006 4:36 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Controlling Return Codes of SORT
- Replies: 1
- Views: 6155
Controlling Return Codes of SORT
Hi,
Here is my requirement
File-A
1234512345
File-B
1234512344
Only one record (of length 10) is present in both File-A and File-B.
If Record(File-A) > Record(File-B) then SORT should return 4
otherwise 0.
So how to get this using any SORT.
Thanks
Kalicharan.
Here is my requirement
File-A
1234512345
File-B
1234512344
Only one record (of length 10) is present in both File-A and File-B.
If Record(File-A) > Record(File-B) then SORT should return 4
otherwise 0.
So how to get this using any SORT.
Thanks
Kalicharan.
- Mon Oct 30, 2006 3:31 pm
- Forum: Admin Announcements
- Topic: STAR MEMBER OF MONTH - FOR OCTOBER 2006
- Replies: 4
- Views: 15273
- Tue Oct 24, 2006 11:39 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: WER426I - SYNCSORT ERROR
- Replies: 2
- Views: 12629
Hi Kris, This problem was solved and sorry for not updating the solution. Here is the update One of the reasons for getting SORT INTERNAL ERROR - RECOVERY ATTEMPT IN PROGRESS from Syncsort is due to assigning the incorrect value (very less file size value) to FILSZ parm in SORT card. The value assig...
- Sat Oct 14, 2006 12:04 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: how to reteieve the cursor randomly??
- Replies: 1
- Views: 13566
Hi, If your requirement is random access to a resultant table you can achieve by scrollable cursor. This mode enables random access to rows in a result set, but currently is supported only by IBM DB2 Universal Database. Scrollable cursors allow random access to a result table. Applications can use a...
- Sat Oct 07, 2006 9:27 am
- Forum: JCL
- Topic: Is it possible to retain 2 versions for a single generation
- Replies: 0
- Views: 6269
Is it possible to retain 2 versions for a single generation
This is an important update regarding versions of a GDG generation. Is it possible to retain 2 versions for a single generation in GDG??? Answer for the above question is absolutely NO. Here is the detailed explanation for the above question Absolute Generation and Version Numbers An absolute genera...
- Fri Sep 29, 2006 11:19 pm
- Forum: Admin Announcements
- Topic: STAR MEMBER AWARD - FOR SEPTEMBER 2006
- Replies: 3
- Views: 14716
- Wed Sep 27, 2006 2:07 pm
- Forum: COBOL
- Topic: hi pls clear my question
- Replies: 2
- Views: 7901
Hi, With Internal Reader - INTRDR , u can submit one job from another Internal reader routines allow TSO jobs or application programs(like COBOL ) to submit job streams to JES3 using output data sets. When a job stream enters the system, data management assigns the data sets directly to an internal ...
- Wed Sep 27, 2006 12:39 pm
- Forum: COBOL
- Topic: i have an query
- Replies: 1
- Views: 4775
Hi, QSAM files can be processed in reverse order using REVERSED keyowrd. Use REVERSED option of the OPEN statement to process files in reverse order. The file is positioned at the end, and READ statements read the data records in reverse order, starting with the last record. The REVERSED option is s...
- Tue Sep 26, 2006 11:14 am
- Forum: JCL
- Topic: anwer this query
- Replies: 1
- Views: 5922
Yes , we can do. One way is to redirect the SYSOUT message to a PS instead of defaultly routing to SPOOL. Alternative way is after the completion of JOB, type SE against syslog,sysjcl in SPOOL. This will open syslog, sysjcl in EDIT MODE . From there u can CUT COPY data into your own PDS. Thanks Kali...
- Tue Sep 26, 2006 10:50 am
- Forum: JCL
- Topic: ISPF question
- Replies: 3
- Views: 11234