Search found 31 matches

by Kalicharan
Fri Oct 23, 2009 11:49 am
Forum: XML
Topic: Cobol XML conversion
Replies: 3
Views: 6029

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 --...
by Kalicharan
Wed Oct 08, 2008 10:34 am
Forum: JCL
Topic: Sending an Email from JCL with attachment
Replies: 36
Views: 77515

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-...
by Kalicharan
Wed Dec 13, 2006 1:11 pm
Forum: EASYTRIEVE
Topic: Usage of THRESHOLD parameter in Easytrieve DATE MACROS
Replies: 1
Views: 6342

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...
by Kalicharan
Thu Nov 16, 2006 12:00 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Deleting large numbers of rows quickly
Replies: 1
Views: 5321

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...
by Kalicharan
Wed Nov 15, 2006 5:46 pm
Forum: JCL
Topic: test datase empty
Replies: 8
Views: 25330

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....
by Kalicharan
Tue Nov 07, 2006 4:36 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Controlling Return Codes of SORT
Replies: 1
Views: 3659

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.
by Kalicharan
Mon Oct 30, 2006 3:31 pm
Forum: Admin Announcements
Topic: STAR MEMBER OF MONTH - FOR OCTOBER 2006
Replies: 4
Views: 9990

Thanks a lot Krishna.

I will send my address details via mail.

Thanks Naga and Jack.
by Kalicharan
Tue Oct 24, 2006 11:39 am
Forum: DFSORT , ICETOOL & Utilities
Topic: WER426I - SYNCSORT ERROR
Replies: 2
Views: 9015

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...
by Kalicharan
Sat Oct 14, 2006 12:04 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: how to reteieve the cursor randomly??
Replies: 1
Views: 9035

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...
by Kalicharan
Sat Oct 07, 2006 9:27 am
Forum: JCL
Topic: Is it possible to retain 2 versions for a single generation
Replies: 0
Views: 3494

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...
by Kalicharan
Fri Sep 29, 2006 11:19 pm
Forum: Admin Announcements
Topic: STAR MEMBER AWARD - FOR SEPTEMBER 2006
Replies: 3
Views: 8670

Three cheers to Frank.
Frank - Congratulations!!!!
Your contributions to this IMG group are excellent



Thanks
Kali.
by Kalicharan
Wed Sep 27, 2006 2:07 pm
Forum: COBOL
Topic: hi pls clear my question
Replies: 2
Views: 6100

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 ...
by Kalicharan
Wed Sep 27, 2006 12:39 pm
Forum: COBOL
Topic: i have an query
Replies: 1
Views: 3276

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...
by Kalicharan
Tue Sep 26, 2006 11:14 am
Forum: JCL
Topic: anwer this query
Replies: 1
Views: 3526

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...
by Kalicharan
Tue Sep 26, 2006 10:50 am
Forum: JCL
Topic: ISPF question
Replies: 3
Views: 7545

Go to SD ST

And then type OWNER *

By this you can se all the USERS who are active along with jobs that are in execution in your system


Thanks
Kalicharan.