Search found 44 matches

by hparthas
Fri Jul 08, 2016 12:24 pm
Forum: COBOL
Topic: Double Byte Character validation
Replies: 0
Views: 2224

Double Byte Character validation

Team - We use Japanese character - Kanji Character set to load our database. I see we are receiving invalid Double byte character which is causing the DB load process to get failed and leading other downstream issues. So I'm looking for any logic in COBOL we can do validation on the data which is re...
by hparthas
Thu Sep 26, 2013 1:42 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Create file from SORTOUT FILE
Replies: 1
Views: 1129

Create file from SORTOUT FILE

Hi, I''m trying to create a file dynamically based on the file reception time and date including microseconds. I have created the and file name how I required and it is available in SORTOUT file. Can you please help me out can I use that file name A.B.C in the SORTOUT file to be created as a FILE NA...
by hparthas
Fri Dec 02, 2011 11:23 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: DBXX NOT OPERATIONAL, RETRY COUNT IS ZERO
Replies: 7
Views: 7908

DBXX NOT OPERATIONAL, RETRY COUNT IS ZERO

Hi archup20,

Have you pointed the DB2 tables using Route card ? Have you checked whether the DBXX region which you are trying to read / update is available when you run the job. check master logs before you re-start the job.

Best Regards,
Harikrishnan
by hparthas
Fri Dec 02, 2011 11:17 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Update DB2 table using any utility
Replies: 1
Views: 1910

Update DB2 table using any utility

Hi all, I have a requirement that I need to update the database once I get the feed, but the key fields will be inserted by another job. Based on the key fields i need to update other few column detail since those values are available in the file only. Is there any utility which will update the valu...
by hparthas
Fri Dec 02, 2011 11:11 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Find and Replace @ Diff positions.
Replies: 1
Views: 1963

Find and Replace @ Diff positions.

Hi All, Can anyone help me with my requirement. My output file contains some incorrect / invalid character I know its HEX values. But I need to replace these HEX values in 2 different ranges. 1) Input file (Sortin) is LRECL 128 2) RECFM = fb 3) First range is from 10-26 4) Second Range is from 70-86...
by hparthas
Fri Oct 14, 2011 11:04 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Compare FB with VB to get VB file
Replies: 2
Views: 6271

Compare FB with VB to get VB file

Hi All, I have a requirement to extract the file, I used Key file as a FB file of 20 LRECL and the data file as 4096 LRECL VB file. The actual data is only 4092 and 4 byte is RDW. My keys are @ first 10 position in both the Key and the data file. I used SORT to match between these two files and extr...
by hparthas
Wed Oct 12, 2011 4:16 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Sort Multiple file with Diff LRECL's
Replies: 2
Views: 5178

Frank,

Thanks a lot for your help in this.

Have moved all the key fields to a particular position and then sorted the complete file.

Thanks,
HK
by hparthas
Tue Oct 11, 2011 10:45 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Sort Multiple file with Diff LRECL's
Replies: 2
Views: 5178

Sort Multiple file with Diff LRECL's

Hi All, I have a requirement and I have to do this in different steps, is there any way that we can do this in a single SORT STEP. Requirement: 1) 11 input files and all are different LRECL. 2) My sort key for all 11 diffferent file are @ different positions. 3) Currently 11 output files are created...
by hparthas
Mon Sep 19, 2011 11:56 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Point to Specific Partition in the DB
Replies: 2
Views: 2453

Hi Dick, Thanks for your update. I can accomplish this by placing exclusive hold on the jobs. We can place one job on hold while the other updates / inserts / delets the database so that this will avoid less failure of the job to get failed due to contention. Yes, I need to load the database with th...
by hparthas
Sat Sep 17, 2011 11:31 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Point to Specific Partition in the DB
Replies: 2
Views: 2453

Point to Specific Partition in the DB

Hi All, Can someone let me know whether shall we point to a specific partition (either update or select or Load) if I know that i will data only for that partition. If i perform this I can avoid contention between jobs. Also I have created my test table where this has 110 columns and total LRECL is ...
by hparthas
Sun Aug 21, 2011 9:17 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: BMC Load REPLACE option
Replies: 5
Views: 8438

Let me try to recover by database with my available files. Good that I have few files. Henceforth, I will schedule a job to take full image copy of my database periodically.

Thanks for your suggestion.

thanks,
HK
by hparthas
Sun Aug 21, 2011 7:58 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: BMC Load REPLACE option
Replies: 5
Views: 8438

Thanks for your suggestion. Since this is a Dev data, i don't think that there will be some backup for my database. I will check with Storage mgmt team if they run any scripts for this at back end for all Dev databases. I checked whether there is any Full image copy for my database. I could not find...
by hparthas
Sat Aug 20, 2011 1:55 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: BMC Load REPLACE option
Replies: 5
Views: 8438

BMC Load REPLACE option

Hi All, I tried to load my Dev table and my table had some lakhs of records, now, unknowingly I used the below Load card to load the database. LOAD REPLACE LOG NO ORDER YES COPY YES UPDATEDB2STATS YES BMCSTATS YES REDEFINE NO INTO TABLE ABCD.TABLE_1_TEST Unfortunately I load all my old data in the t...
by hparthas
Tue Mar 29, 2011 4:10 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Need help to compare 2 files and write the matched records
Replies: 18
Views: 32255

Need help to compare 2 files and write the matched records

Hi Preeti, Here is the SORT Card which will work in SYNCSORT !!!! //S1 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //IN1 DD DSN=... input file1 (FB/8) //IN2 DD DSN=... input file2 (FB/107) //SORTOUT DD DSN=... output file (FB/99) //SYSIN DD * JOINKEYS FILE=F1,FIELDS=(1,8,A) JO...
by hparthas
Mon Feb 28, 2011 12:34 am
Forum: Admin Announcements
Topic: DB2 QUICK START - FREE for Members
Replies: 81
Views: 107631

Hi Krishna,

Please provide the password number for 450

Many thanks in advance

Harikrishnan