 |
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 12 matches |
| Author | Message |
|---|---|
 Topic: Platinum Rapid Recovery issue |
|
| pkrish_18 Replies: 3 Views: 1531 |
 Forum: Database Posted: Thu Mar 29, 2007 12:02 pm Subject: Platinum Rapid Recovery issue |
| I mean, It'll not be worthy now, to check the table count as it has underwent some processing. | |
| Topic: Platinum Rapid Recovery issue |
|
| pkrish_18 Replies: 3 Views: 1531 |
Forum: Database Posted: Thu Mar 29, 2007 12:00 pm Subject: Platinum Rapid Recovery issue |
| Yes ..It is a Unique Index.
It'll be worthy to check the count in the table now, as lot of processing has happend on the table. |
|
| Topic: Platinum Rapid Recovery issue |
|
| pkrish_18 Replies: 3 Views: 1531 |
Forum: Database Posted: Mon Mar 26, 2007 6:14 pm Subject: Platinum Rapid Recovery issue |
| Hi,
My full image copy dataset has got 13519 records( Unloaded from IC and verified the count). When I tried to recover using the above Full IC dataset, the statistics which the recovery job output ... |
|
| Topic: Compare Char column and Interger in wher clause of Join |
|
| pkrish_18 Replies: 4 Views: 2034 |
Forum: Database Posted: Thu Feb 22, 2007 11:40 am Subject: Compare Char column and Interger in wher clause of Join |
| Am really sorry. Column defn for SD.FK_SALES_ITEM_RAN is INTEGER. And when we try to compare PA.PICK_CAND_ORD_LINE(which is defined as CHAR), it throughs an error. So the only choice is to compare by ... | |
| Topic: Compare Char column and Interger in wher clause of Join |
|
| pkrish_18 Replies: 4 Views: 2034 |
Forum: Database Posted: Wed Feb 21, 2007 4:10 pm Subject: Compare Char column and Interger in wher clause of Join |
| Hi ,
Am running the following query, SELECT * FROM Qualifier.T1 SD, Qualifier.T2 PA WHERE PA.PICK_CAND_ORD_HDR = SD.FK_SALES_ORDER_NUM AND INTEGER(PA.PICK_CAND_ORD_LINE) = ... |
|
| Topic: Order by clause in DB2 |
|
| pkrish_18 Replies: 1 Views: 1196 |
Forum: Database Posted: Tue Mar 07, 2006 7:54 am Subject: Order by clause in DB2 |
| I'm running the following query..
SELECT * FROM RBPRDB.T1508 WHERE SO_CD = 'EO1148HJ' AND SI_NUM = 01 ... |
|
| Topic: Reorg or Load after altering and adding col to DB2 table. |
|
| pkrish_18 Replies: 1 Views: 924 |
Forum: Database Posted: Fri Jul 15, 2005 6:15 am Subject: Reorg or Load after altering and adding col to DB2 table. |
| Hi,
Is it mandatory for us to do a Reorg or Load after altering and adding a col to DB2 table. Is there any impacts if we don't do a reorg after altering the table.. Regards, krish |
|
| Topic: Inserting to VARCHAR(1190) with more than 255 chars. |
|
| pkrish_18 Replies: 3 Views: 2170 |
Forum: Database Posted: Sat Jun 04, 2005 9:08 am Subject: Inserting to VARCHAR(1190) with more than 255 chars. |
| Hi,
Thru spufi or QMF, if I try to Insert value for a VARCHAR(1190) db2 column, (the actual value which I am trying to insert is more than 300 chars length) , it through's an SQLCODE -102 LITERAL S ... |
|
| Topic: Max Value which PIC S9(5)V9(4) can hold |
|
| pkrish_18 Replies: 2 Views: 2245 |
Forum: Application Programming Posted: Tue May 24, 2005 6:27 am Subject: Max Value which PIC S9(5)V9(4) can hold |
| Hi,
Can you pls let me know the max value which the following variable can hold? TGT-ITEM-TRANSFER-PRICE PIC S9(5)V9(4) COMP. It will be preferable if you can tell me how much the real part ... |
|
| Topic: Converting S9(18) comp to PD |
|
| pkrish_18 Replies: 6 Views: 4897 |
Forum: Utilities Posted: Tue Apr 12, 2005 11:34 am Subject: Converting S9(18) comp to PD |
| Thanks a lot Kolusu and Yaeger for your valuable inputs.... | |
| Topic: Converting S9(18) comp to PD |
|
| pkrish_18 Replies: 6 Views: 4897 |
Forum: Utilities Posted: Mon Apr 11, 2005 12:37 pm Subject: Converting S9(18) comp to PD |
| Thx a lot Kolusu and yaeger for your kind reply....
Can you pls tell me how to differentiate a DFSORT from SYNCSORT. I believe that,we invoke the sort utility by a SORT command.... But How ca ... |
|
| Topic: Converting S9(18) comp to PD |
|
| pkrish_18 Replies: 6 Views: 4897 |
Forum: Utilities Posted: Mon Apr 11, 2005 4:11 am Subject: Converting S9(18) comp to PD |
| Hi,
While tring to convert S9(18 ) COMP to PD, using sort, it is throughing error.. Copybook field : 11 MAINT-DATES-AND-TIME PIC S9(18 ) COMP. Sort CNTLCARD: //SYSIN ... |
|
All times are GMT - 5 Hours |