Search found 152 matches
- Wed Mar 25, 2009 9:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Inserts
- Replies: 21
- Views: 6615
- Wed Mar 25, 2009 8:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Inserts
- Replies: 21
- Views: 6615
Re: Oracle Inserts
if the record already exists on a key, do you want to update the record (in the table) with the new one or you want to reject that record???
- Wed Mar 25, 2009 8:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Procedure fails with incorrect SET options
- Replies: 10
- Views: 4130
Re: Stored Procedure fails with incorrect SET options
Are you calling the store procedure in a OPEN/CLOSE command in ODBC Enterprise stage???
- Tue Mar 24, 2009 2:06 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: getting rows between two dates
- Replies: 11
- Views: 4715
Re: getting rows between two dates
CAN YOU BE MORE SPECIFIC??
- Fri Mar 20, 2009 12:10 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: bitmap indexes performance
- Replies: 8
- Views: 3057
- Fri Mar 20, 2009 11:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: bitmap indexes performance
- Replies: 8
- Views: 3057
- Thu Mar 12, 2009 8:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Pading char
- Replies: 3
- Views: 1169
Re: Pading char
you can mention padchar in the FORMAT tab under TYPEDEFAULTS->GENERAL section...
you should be able to accomodate reading the file with padchar..
you should be able to accomodate reading the file with padchar..
- Thu Mar 12, 2009 7:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Pading char
- Replies: 3
- Views: 1169
Re: Pading char
can you be more specific..about your files?? what is the problem reading the files using sequentail files??
- Wed Mar 11, 2009 1:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: StingtoDate
- Replies: 6
- Views: 1837
Re: StingtoDate
using this format would solve the issue
Code: Select all
StringToDate(SRC.DATE,'%m/%d/%yyyy')
- Wed Mar 11, 2009 1:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: StingtoDate
- Replies: 6
- Views: 1837
Re: StingtoDate
repost
- Wed Mar 11, 2009 1:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: StingtoDate
- Replies: 6
- Views: 1837
Re: StingtoDate
using this format would solve the issue
Code: Select all
StringToDate(SRC.DATE,'%m/%d/%yyyy')
- Tue Mar 10, 2009 11:45 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Update query in ODBC
- Replies: 2
- Views: 2417
Re: Update query in ODBC
post the complete error
- Mon Mar 09, 2009 11:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle open command
- Replies: 10
- Views: 4598
node_node0: Player 1 terminated unexpectedly. main_program: APT_PMsectionLeader(1, node0), player 1 - Unexpected exit status 1. main_program: Step execution finished with status = FAILED. warning --- main_program: Received SIGPIPE signal caused by closing of the socket on port 13,400. No output wil...
- Mon Mar 09, 2009 11:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle open command
- Replies: 10
- Views: 4598
Re: Oracle open command
repost
- Mon Mar 09, 2009 11:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle open command
- Replies: 10
- Views: 4598
Re: Oracle open command
repost