Author |
Message |
Topic: Split Name Column into Firstname, Lastname, Middlename,sufx |
schintala
Replies: 6
Views: 5639
|
Forum: Database Posted: Tue Mar 20, 2012 1:20 pm Subject: Split Name Column into Firstname, Lastname, Middlename,sufx |
Kolusu,
Thank you so much for your valuable update on the SQL. We have developed cobol program to read the data from the name column and inserted into other columns after splitting. As the data in n ... |
Topic: Split Name Column into Firstname, Lastname, Middlename,sufx |
schintala
Replies: 6
Views: 5639
|
Forum: Database Posted: Mon Mar 19, 2012 12:48 pm Subject: Split Name Column into Firstname, Lastname, Middlename,sufx |
Hi,
I have a table and one of the column is name with CHAR(25). The name is first name followed by Middle name and last name with comma separated and suffix at the end if there any. Not all the nam ... |
Topic: DB2 Date and Time Concatenation |
schintala
Replies: 4
Views: 4729
|
Forum: Database Posted: Thu Jan 26, 2012 8:33 am Subject: DB2 Date and Time Concatenation |
Thank you so much. It worked. |
Topic: DB2 Date and Time Concatenation |
schintala
Replies: 4
Views: 4729
|
Forum: Database Posted: Wed Jan 25, 2012 2:09 pm Subject: DB2 Date and Time Concatenation |
Kolusu,
Thank you so much for the reply. Time stored as HHMM in CHAR(4). Yes. We will store the seconds and microseconds are zeros in new column. |
Topic: DB2 Date and Time Concatenation |
schintala
Replies: 4
Views: 4729
|
Forum: Database Posted: Wed Jan 25, 2012 12:35 pm Subject: DB2 Date and Time Concatenation |
Hi,
I have a table that have two columns to store date and time. Date column defined as Date data type where as Time column defined as CHAR(4). We would like to alter the table for an additional colu ... |
Topic: Remote Aliases in DB2 LUW |
schintala
Replies: 2
Views: 3258
|
Forum: Database Posted: Wed Jan 04, 2012 4:20 pm Subject: Remote Aliases in DB2 LUW |
Hi,
We have DB2 databases listed on z/OS. We want to work with aliases in DB2 LUW, but physical databases resides on z/OS. Can we create alias to those in LUW DB2? Please advise. Does it work?
T ... |
Topic: Load utility DSNUTILB only loading one table per *JOB* |
schintala
Replies: 5
Views: 4238
|
Forum: Database Posted: Tue May 10, 2011 1:49 pm Subject: Load utility DSNUTILB only loading one table per *JOB* |
Just curious, are those tables are in one table space as segmented. If it so, you may have to change load control card to load them properly. Looks to me those tables are in one table space. Check it ... |
Topic: SQL help for finding the Max TOTAL based on Date |
schintala
Replies: 2
Views: 1791
|
Forum: Database Posted: Tue May 03, 2011 10:55 am Subject: SQL help for finding the Max TOTAL based on Date |
Kolusu,
Thank you so much. I made it so complex. You made so simple I can't believe and it ran quick in secs. Thank you very much sir. |
Topic: SQL help for finding the Max TOTAL based on Date |
schintala
Replies: 2
Views: 1791
|
Forum: Database Posted: Mon May 02, 2011 1:38 pm Subject: SQL help for finding the Max TOTAL based on Date |
Hi,
This could be a simple. I am bad at writing SQL. Please pardon me.
Below is my SQL. I need to get the max(total) and corresponding date (PRCS_DT) associated to it. When I use group by on date ... |
Topic: Stored Procedure |
schintala
Replies: 2
Views: 1849
|
Forum: Database Posted: Mon May 02, 2011 1:08 pm Subject: Stored Procedure |
You can browse the catalog tables SYSIBM.SYSPARMS and SYSIBM.ROUTINES to know the in and out parms of procedures. |
Topic: CA Fastload Utility Error |
schintala
Replies: 7
Views: 6375
|
Forum: Database Posted: Mon Mar 14, 2011 1:49 pm Subject: CA Fastload Utility Error |
Want to update you, the issue has been resolved and it is due to size of REGION parameter in the job card. In job step we coded as REGION=5M and in step we made it as 0M. Job card region overrides the ... |
Topic: CA Fastload Utility Error |
schintala
Replies: 7
Views: 6375
|
Forum: Database Posted: Fri Mar 11, 2011 4:25 pm Subject: CA Fastload Utility Error |
Thank you all. Just want to update you, this abend due to locks held on the load table by some thread. CA Fastload Utilty trying to stop the table/index space and could not do because it was in use by ... |
Topic: CA Fastload Utility Error |
schintala
Replies: 7
Views: 6375
|
Forum: Database Posted: Fri Mar 11, 2011 12:08 pm Subject: CA Fastload Utility Error |
Kolusu,
Thank you so much for the reference. Our CA DB2 products has been upgraded from R11SP2 to R14.0 recently. Not all CA Fastload utility jobs gives this error. This error comes from in one job. ... |
Topic: CA Fastload Utility Error |
schintala
Replies: 7
Views: 6375
|
Forum: Database Posted: Fri Mar 11, 2011 11:03 am Subject: CA Fastload Utility Error |
Hi,
I am trying to load the data into table using CA fastload utility and failed with S000 U0100 abend. Any clue? I see below error message from the utility.
PFL0111E - Storage Acquisition failed ... |
Topic: Unload from Image Copy |
schintala
Replies: 2
Views: 3033
|
Forum: Database Posted: Fri Feb 18, 2011 3:51 pm Subject: Unload from Image Copy |
Kolusu,
Thank you so much. It worked now. Have a good week end. |
|