 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 10 matches |
| Author | Message |
|---|---|
 Topic: Convert date format |
|
| sri_naveen Replies: 14 Views: 5151 |
 Forum: Database Posted: Wed Mar 03, 2004 11:34 pm Subject: Convert date format |
| hi ace...
There is a paper in CMU coming up on AI support for DB2 There is a seperate predictive query routine designed for this purpose. If you still cant map forecasting to that, forget it. Rem ... |
|
| Topic: Convert date format |
|
| sri_naveen Replies: 14 Views: 5151 |
Forum: Database Posted: Wed Mar 03, 2004 9:14 am Subject: Convert date format |
Oh no..not again... I think you are obsessed with DB2 ... 
In this case, updating the table (with a hazaar rows) , cursors are indeed the best bet. But can't we just recall what the issue was ? ... |
|
| Topic: Convert date format |
|
| sri_naveen Replies: 14 Views: 5151 |
Forum: Database Posted: Wed Mar 03, 2004 7:24 am Subject: Convert date format |
| Hi kolusu..
haha... I wasnt poking fun.. Maybe I wasn't interpreted properly. In your example with a cursor, I wonder why you need to do all those steps. You can always find cases where an ap ... |
|
| Topic: Convert date format |
|
| sri_naveen Replies: 14 Views: 5151 |
Forum: Database Posted: Wed Mar 03, 2004 5:30 am Subject: Convert date format |
| Hi ace,
I had a hearty laugh at this stuff posted.... Lemme tell u one thing in programming. Anything can be done with anything. I can code an entire prime number logic or weather ... |
|
| Topic: Mass Insert into a table |
|
| sri_naveen Replies: 5 Views: 2721 |
Forum: Database Posted: Tue Dec 30, 2003 11:51 pm Subject: Mass Insert into a table |
| Hi vani,
I meant you can write your insert/update logic inside an element and link it from inside a JCL After the EXEC stt..templink your element.. INCLUDE SYSLIB(Element) INCLUDE LO ... |
|
| Topic: Mass Insert into a table |
|
| sri_naveen Replies: 5 Views: 2721 |
Forum: Database Posted: Tue Dec 30, 2003 10:32 am Subject: Mass Insert into a table |
| Hi vani,
250 million records..sounds a really robust application...for this .. you need to use a cursor on the table for updates....thats the best bet db2 can offer for huge records.. talking about ... |
|
| Topic: In memeory cache / database |
|
| sri_naveen Replies: 3 Views: 1812 |
Forum: Database Posted: Tue Dec 30, 2003 4:23 am Subject: In memeory cache / database |
| Hi Vani,
Stored procedures are alright if you also constantly update info, but since this is a typical read only stuff that needs to reside in MM, you can use the time tested Object Oriented ... |
|
| Topic: SQL queries(DB2) on MVS |
|
| sri_naveen Replies: 2 Views: 2269 |
Forum: Database Posted: Tue Dec 30, 2003 4:15 am Subject: SQL queries(DB2) on MVS |
| Hi...
In MVS, "groupby" has certain restrictions...so does "orderby",..and hey nivedita...if you really want to do any mass insert/update , use triggers instead of type I/II queries ...I perso ... |
|
| Topic: C - DB2 Program |
|
| sri_naveen Replies: 2 Views: 1505 |
Forum: Database Posted: Mon Nov 10, 2003 11:35 pm Subject: C - DB2 Program |
| Vani..
The db2 code embedded in the host language is the middle tier...if you need to directly pass the parameters using JCL .. there is a DD parameter option to attach objects created in a HLL ... |
|
| Topic: SQL QUERY |
|
| sri_naveen Replies: 4 Views: 1969 |
Forum: Database Posted: Mon Nov 10, 2003 11:29 pm Subject: SQL QUERY |
| Hi vani...try this..
SELECT MAX(GDAT) FROM <your table T1>, <same table T2> WHERE T1.NLBKZ <> T2.NLBKZ AND <same for other two> this is a b ... |
|
All times are GMT - 5 Hours |