Author |
Message |
Topic: Load DB2 table using GDG |
satyenderd
Replies: 2
Views: 2780
|
Forum: Database Posted: Wed Aug 25, 2010 1:50 pm Subject: Load DB2 table using GDG |
It worked.
Thanks a lot Kolusu for your time.
|
Topic: Load DB2 table using GDG |
satyenderd
Replies: 2
Views: 2780
|
Forum: Database Posted: Tue Aug 24, 2010 2:14 pm Subject: Load DB2 table using GDG |
Hi all,
I have a question regarding how to load from GDG?
I have taken a image copy to GDG.
Then I have unloaded it to a dataset.
Then when i tried to load into table i got all junk values in ... |
Topic: DB2 COMMANDS (-START DATABASE(ABC) SPACENAM(*) ACCESS(RW) |
satyenderd
Replies: 2
Views: 4273
|
Forum: Database Posted: Mon Aug 23, 2010 2:05 pm Subject: DB2 COMMANDS (-START DATABASE(ABC) SPACENAM(*) ACCESS(RW) |
Kolusu,
Sorry for my delay in replying to this post.
I was sick all these days.
Thanks for the answer.
But, here is the thing..I am currently using the Batch JCL to remove the pending status.. ... |
Topic: DB2 COMMANDS (-START DATABASE(ABC) SPACENAM(*) ACCESS(RW) |
satyenderd
Replies: 2
Views: 4273
|
Forum: Database Posted: Fri Aug 13, 2010 4:21 pm Subject: DB2 COMMANDS (-START DATABASE(ABC) SPACENAM(*) ACCESS(RW) |
Hi all,
Herein is my question:
Is it is possible to execute DB2 commands like START DATABASE using DB2 command line processor or batch file or stored procedure?
Reference:
http://publib.boul ... |
Topic: REC2XML on Mainframe DB2 |
satyenderd
Replies: 8
Views: 5154
|
Forum: Database Posted: Tue Mar 16, 2010 5:47 pm Subject: REC2XML on Mainframe DB2 |
Kolusu,
I am just trying this option on both platforms and I have encountered.
As it is in DB2 UDB, I have assumed that it may also be in Mainframes.
Anyways, thank you for your help.
Thanks t ... |
Topic: REC2XML on Mainframe DB2 |
satyenderd
Replies: 8
Views: 5154
|
Forum: Database Posted: Tue Mar 16, 2010 3:28 pm Subject: REC2XML on Mainframe DB2 |
Papadi,
On the mainframes it is throwing an error SQLCODE -440.
|
Topic: REC2XML on Mainframe DB2 |
satyenderd
Replies: 8
Views: 5154
|
Forum: Database Posted: Tue Mar 16, 2010 1:32 pm Subject: REC2XML on Mainframe DB2 |
Hi all for your quick responses.
Kolusu, the query executed on windows without any error.
SET CURRENT SQLID = 'ESDD2ADM';
SELECT REC2XML( 1.0, 'COLATTVAL','MKT_MAILING'
... |
Topic: REC2XML on Mainframe DB2 |
satyenderd
Replies: 8
Views: 5154
|
Forum: Database Posted: Tue Mar 16, 2010 12:49 pm Subject: REC2XML on Mainframe DB2 |
Hi all,
This is regarding REC2XML.
When I tried this option it went fine on windows but not able to execute on Mainframes.
Ended with SQLCODE -440 and SQLSTATE 42884 on mainframes.
Could anyon ... |
Topic: Regarding Details Pane in control center for DB2 |
satyenderd
Replies: 1
Views: 1430
|
Forum: Database Posted: Wed Oct 21, 2009 1:56 pm Subject: Regarding Details Pane in control center for DB2 |
Hi all,
This is regarding DB2 COTROL CENTER details pane on the right bottom of the screen for the mainframe environment.
I am selecting CONTROL CENTER INTERFACE as ADVANCED to connect to mainfr ... |
Topic: FTP text file to mainframes |
satyenderd
Replies: 4
Views: 9022
|
Forum: Utilities Posted: Fri Oct 16, 2009 6:53 pm Subject: FTP text file to mainframes |
Thanks Kolusu for your quick response.
I am looking into the JCL, I will update the posting once i come up with soultion or end up with errors. |
Topic: FTP text file to mainframes |
satyenderd
Replies: 4
Views: 9022
|
Forum: Utilities Posted: Thu Oct 15, 2009 2:50 pm Subject: FTP text file to mainframes |
Hi all,
This is regarding FTP text file to Dataset in mainframes.
(I have searched couple of links posted earlier in this forum. I found mostly they are related FTP to windows from mainframes.
I ha ... |
Topic: DB2 UNLOAD Utility |
satyenderd
Replies: 3
Views: 4206
|
Forum: Utilities Posted: Wed Sep 30, 2009 4:52 pm Subject: DB2 UNLOAD Utility |
Hi Kolusu,
I forgot to mention that the table has been created in UNICODE.
Since encoding scheme for the tablespace is UNICODE, the data is unloaded in UNICODE. To get the data unloaded and con ... |
Topic: DB2 LOAD problem |
satyenderd
Replies: 6
Views: 2438
|
Forum: Utilities Posted: Fri Sep 25, 2009 11:01 am Subject: DB2 LOAD problem |
Data in the text file:
11387 "RANDY" " |
Topic: DB2 LOAD problem |
satyenderd
Replies: 6
Views: 2438
|
Forum: Utilities Posted: Fri Sep 25, 2009 10:49 am Subject: DB2 LOAD problem |
Hi Kolusu,
As I a using TN3270 emulator, I did see those options.
Herein is the screenshot.
In the send options there is only two options in the drop down. CRLF and LF.
I am unable to send you ... |
Topic: DB2 LOAD problem |
satyenderd
Replies: 6
Views: 2438
|
Forum: Utilities Posted: Thu Sep 24, 2009 9:02 pm Subject: DB2 LOAD problem |
Thank you Kolusu for that information.
I will check that and will update you. |
|