Search found 44 matches

by hparthas
Fri Feb 25, 2011 11:33 pm
Forum: Admin Announcements
Topic: DB2 QUICK START - FREE for Members
Replies: 81
Views: 154742

Hi Krishna,

Please provide the password number for 450

Many thanks in advance

Harikrishnan
by hparthas
Fri Feb 25, 2011 11:21 pm
Forum: IMS DB
Topic: How to Identify file name from DBD name
Replies: 3
Views: 7189

Anuj, I'm trying to update the IMS database such that my input records will be matched correctly with the database values and write the same in O/P file. The current scenario is my Pgm is not writing the records in O/P instead in Reject file. I need to correct this situation, so that my I/P records ...
by hparthas
Mon Feb 07, 2011 9:52 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Query using DELETE
Replies: 6
Views: 22027

Krishna please find the SQL query. I tried to SELECT the database to check whether any qualified rows are available in the DB, and can see few rows fetched. When I changed SELECT to DELETE the SQL is throwing +100 SQL error. Delete Query : DELETE FROM TABLE.PROD_TBLE WHERE PRD_ID_DESC LIKE ('%48...
by hparthas
Sun Feb 06, 2011 10:00 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Query using DELETE
Replies: 6
Views: 22027

Thanks Krishna !!!! I have changed LIKE to IN and the database have not been updated. Instead I tried to SELECT the database with IN and the query resultant is '0' rows, but the table has records. If I perform the same with single PRD_ID_DESC and 2 rows been fetched from my resultant query. Please a...
by hparthas
Sat Feb 05, 2011 9:44 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Query using DELETE
Replies: 6
Views: 22027

Query using DELETE

Hi, I need to update the database based on the list of Product details. My Table is defined as below Filed Name : PRD_ID_DESC Length : 50 The field comprises of Product ID (LENGTH - 6 CHAR) , some spaces, and Product desc. I have the list of Product ID (LENGTH - 6 CHAR) and I need to delete from tab...
by hparthas
Mon Jan 31, 2011 10:57 pm
Forum: IMS DB
Topic: How to Identify file name from DBD name
Replies: 3
Views: 7189

How to Identify file name from DBD name

Hi, I'm struck up in finding the VSAM / OSAM dataset name for an IMS Database. I'm trying to edit the database for one particular filed manually in my Test environment, to complete test phase of my IMS code. Could you please guide me in right direction to identify the dataset name. Many thanks in ad...
by hparthas
Tue Jan 25, 2011 11:15 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: How to Generate numbers Using SORT
Replies: 2
Views: 4524

Thanks a lot Frank !!!!. I tried the file with 999999999 records in my file.

Thanks again for your help in this !!!!
by hparthas
Sun Jan 23, 2011 11:38 am
Forum: DFSORT , ICETOOL & Utilities
Topic: How to Generate numbers Using SORT
Replies: 2
Views: 4524

How to Generate numbers Using SORT

Hi,

I have a requirement to generate numbers. I know the starting number and ending number, I need to generate this SORT, is this possible ?

Starting number is : 917000000000001
Ending number is : 917000999999999

Any help would be great !!!!

Thanks
by hparthas
Tue Jan 18, 2011 9:43 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: VSAM & DB2 Comparion
Replies: 10
Views: 12233

Thanks a lot, will check and proceed accordingly !!!!
by hparthas
Tue Jan 18, 2011 9:43 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: VSAM & DB2 Comparion
Replies: 10
Views: 12233

Thanks a lot, will check and proceed accordingly !!!!
by hparthas
Mon Jan 17, 2011 8:41 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: VSAM & DB2 Comparion
Replies: 10
Views: 12233

Thanks Krishna and Anuj !!!! Please find my answers: 1. Total size of data, based on Record size ( total no of records * total size ) - 1 million records and 1300 Record length 2. No of applications going to use this data concurrently - Probably less than 4 jobs will access this database concurrentl...
by hparthas
Sun Jan 16, 2011 11:32 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: VSAM & DB2 Comparion
Replies: 10
Views: 12233

Thanks Krishna, but my query was which is better either VSAM or DB2 in terms of performance !!!!

Thanks !!!!
by hparthas
Thu Jan 13, 2011 10:40 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: VSAM & DB2 Comparion
Replies: 10
Views: 12233

VSAM & DB2 Comparion

Hi, I need to load 100 million of records. I need to refer this database based on 3 basic keys from my input file. I need to load 100 million records as this is the first time to load with live data. Also this database will be refreshed on daily basis. Kindly can some tell me which is best suit to h...
by hparthas
Sun Jan 02, 2011 10:27 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Database RW,UTUT Error - S04E loading data
Replies: 9
Views: 22914

Yes, I have included the step. Do you have any other to solve this !!!!

Thanks & Regards,
Harikrishnan
by hparthas
Fri Dec 31, 2010 9:36 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Database RW,UTUT Error - S04E loading data
Replies: 9
Views: 22914

Database RW,UTUT Error - S04E loading data

Hi, My job is trying to load DB2 table. When I try to load the database my job failed with S04E return code. When I check this, I found that the database is in RW,UTUT status. I have cleared this through TERM UTILID and the database was in RW status again. When I re-start the job again after some ti...