Search found 21 matches
- Mon Feb 02, 2009 1:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Insert binary data into Teradata?
- Replies: 0
- Views: 1990
Insert binary data into Teradata?
Hi, I have a column in teradata table defined as byte(2). How can I insert Hex data (say for ex: 'D0C6') into this table in Datastage. Do i have to use a Modify stage and if so, what is the conversion function needed to convert data into byte format. P.S.: from command line this is how i insert data...
- Fri Jan 02, 2009 5:10 am
- Forum: General
- Topic: Datastage Certification
- Replies: 8
- Views: 4785
- Fri Jan 02, 2009 5:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Teradata-Retrieve data from tables in Multiple databases
- Replies: 4
- Views: 2763
- Thu Jan 01, 2009 9:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Teradata-Retrieve data from tables in Multiple databases
- Replies: 4
- Views: 2763
Teradata-Retrieve data from tables in Multiple databases
Hi, Using a Teradata Enterprise Stage, Could anyone pls. let me know how to retrieve data by joining tables available in different databases. :shock: When Database option is not set, the stage tries to read from default user database, but I have to read data from 2 databases other than user default ...
- Tue Dec 16, 2008 10:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to have Input File name as Output
- Replies: 4
- Views: 2543
- Tue Dec 16, 2008 2:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to have Input File name as Output
- Replies: 4
- Views: 2543
- Tue Feb 27, 2007 3:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Renaming a File with Current Date
- Replies: 6
- Views: 2342
hi yashwin, Why are you creating the file and then trying to rename it? If you cannot change the existing file name, then that's fine but you can parameterize the filename in the DataStage job. Add a new parameter CycleDate to your list of parameters and in the datastage job the filename can be code...
- Fri Dec 01, 2006 8:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem with FTP PLUGin stage when used for FIXED Width file
- Replies: 9
- Views: 4573
- Thu Nov 30, 2006 1:28 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 enterprise stage - Reject handling
- Replies: 5
- Views: 2442
Ya ..thats true..if the commit point is greater than the number of records being loaded, then a commit will be issued when the stage / job closes (correct me if i am wrong). Scenario 1: Input number of records : 90 Bad records : 0 For this scenario, all records were loaded (and committed), irrespect...
- Wed Nov 29, 2006 1:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 enterprise stage - Reject handling
- Replies: 5
- Views: 2442
DB2 enterprise stage - Reject handling
Hi, This is in regard with the DB2 EE stage... I have done a search in the forum..but was not able to find an appropriate solution The problem is as follows. The job is a simple one..Seqfile -> transformer -> DB2 enterprise stage(Upsert strategy ) ---> Seq file (to capture rejects) The DB2 table has...
- Thu Nov 23, 2006 1:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Negative Elapsed Time (- rows/sec link count)
- Replies: 8
- Views: 3329
yes Arnd, DB2 is on a remote server. There is a time difference between the DataStage server and the database remote server. The datastage server time is ahead by about 1 minute and 13 seconds than the database server. But is it not that the start time and end time are reported by DataStage server a...
- Thu Nov 23, 2006 11:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Negative Elapsed Time (- rows/sec link count)
- Replies: 8
- Views: 3329
I have run the job again and the following are the details as seen in the job monitor. These are the statistics for a DB2 output link. start time: 11/23/2006 12:06:19 PM end time: 11/23/2006 12:05:43 PM elapsed time: -01:59:24 Link Count : -18106 rows/sec. Row Count: 651827 How can the end time on t...
- Thu Nov 23, 2006 10:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Negative Elapsed Time (- rows/sec link count)
- Replies: 8
- Views: 3329
- Thu Nov 23, 2006 10:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Negative Elapsed Time (- rows/sec link count)
- Replies: 8
- Views: 3329
Negative Elapsed Time (- rows/sec link count)
Hi ,
Can somebody pls. let me know what is the meaning of getting negative row count on the Links between two stages.
[ex: -13037 rows/sec]
Thanks,
Can somebody pls. let me know what is the meaning of getting negative row count on the Links between two stages.
[ex: -13037 rows/sec]
Thanks,
- Fri Nov 03, 2006 2:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Link Count shows as 0rows/sec when RCP is enabled
- Replies: 4
- Views: 2742