Hi:
Please let me know the unix command to see the running status of the job from unix.
Thanks in Advance
cnu
Search found 38 matches
- Mon Oct 06, 2008 3:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Monitor the status of Datastage job from unix
- Replies: 1
- Views: 1664
- Fri Aug 29, 2008 9:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading from oracle enterprise stage
- Replies: 5
- Views: 2162
TRN_NUMBER in Source NUMBER(8) ,Oracle database. TRN_NUMBER in Target is int,SQLSERVER database. both are NOT NULL columns. I am using Oracle enterprise stage in source and DRS stage in Targetside. Its giving below warning. Orc_Rtetrieve_Rgw: When checking operator: When binding output interface fie...
- Wed Aug 27, 2008 9:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading from oracle enterprise stage
- Replies: 5
- Views: 2162
- Tue Aug 26, 2008 2:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading from oracle enterprise stage
- Replies: 5
- Views: 2162
Reading from oracle enterprise stage
Hi: I am getting the below error when i am reading the data from oracle. Orc_Rtetrieve_Rgw: When checking operator: When binding output interface field "TRN_NUMBER" to field "TRN_NUMBER": Implicit conversion from source type "string[max=40]" to result type "int32&q...
- Wed Aug 06, 2008 12:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp in the Dynamic_RDBMS stage in Sql server database
- Replies: 6
- Views: 3262
- Wed Aug 06, 2008 8:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp in the Dynamic_RDBMS stage in Sql server database
- Replies: 6
- Views: 3262
- Tue Aug 05, 2008 6:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp in the Dynamic_RDBMS stage in Sql server database
- Replies: 6
- Views: 3262
- Tue Aug 05, 2008 6:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Load the data by using Dynamic RDBMS Stage in the SQLSERVER
- Replies: 3
- Views: 1633
- Tue Aug 05, 2008 3:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp in the Dynamic_RDBMS stage in Sql server database
- Replies: 6
- Views: 3262
Timestamp in the Dynamic_RDBMS stage in Sql server database
Hi: I am sending the currenttimestamp() from the transformer to created_dt field , which is specified as Timestamp() in the meatadata. I am getting the below warning message.Please advice me what conversion is required to rectify the below warning. Dynamic_RDBMS_Load_Stage_tbl,0: Warning: DsRGW.Dyna...
- Tue Aug 05, 2008 10:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Load the data by using Dynamic RDBMS Stage in the SQLSERVER
- Replies: 3
- Views: 1633
Load the data by using Dynamic RDBMS Stage in the SQLSERVER
Hi: I am using the Dynamic RDBMS Stage to load the data in SQL SERVER database in the target side. My requirement is inserting the new records only. For example im getting the 12 records from source, but 10 records already therein the target table,i have to insert only 2 records means ignore the exi...
- Sun Aug 03, 2008 6:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DatrTime in SQLSERVER
- Replies: 13
- Views: 4304
- Sun Aug 03, 2008 5:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DatrTime in SQLSERVER
- Replies: 13
- Views: 4304
Thanks Ray !! I want a same source date format in the target also,but there is no date datatype in the target SQL Server, only datetime is there. Is there any datatype is available for only date.We can change the metadata. Please advice me how can i get only date same as souce to the target. If I ha...
- Sat Aug 02, 2008 10:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DatrTime in SQLSERVER
- Replies: 13
- Views: 4304
- Sat Aug 02, 2008 9:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DatrTime in SQLSERVER
- Replies: 13
- Views: 4304
Thanks for quick reply !! I am getting date from oracle database as mm/dd/yyyy format. Datatype is Date in Oracle source. In the target Datatype is datetime.I need a same format mm/dd/yyyy in the target SQL Server also. If i map the date to Datetime field in the Transformer,can i get the mm/dd/yyyy....
- Sat Aug 02, 2008 7:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DatrTime in SQLSERVER
- Replies: 13
- Views: 4304
Thanks !! Target is Sqlserver.So date is coming from Oracle source i form of mm/dd/yyyy.I need a same format in the target. In the SQL server DDL is Datetime. Can i map the field from date to datetime in the transformer. In SQL Server database datatype is Datetime available,date is not there. So can...