Search found 1213 matches
- Mon Dec 15, 2008 3:50 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Input column does not promote to output column
- Replies: 5
- Views: 5361
Re: Input column does not promote to output column
Hi I am passing 10 column as the input to sort stage and taking the same number of columns as the output. But in the run time i am getting the error "Input column does not promote to output column" Can any one help me in this? Thanks in advance Ram There is no change. Both input and outpu...
- Mon Dec 15, 2008 3:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: OCI Stage - Issue with reading decimal values
- Replies: 11
- Views: 4989
Re: OCI Stage - Issue with reading decimal values
Hi Try to read it as varchar. Ram Hi, I am reading data from an Oracle table using OCI stage but the decimal data seems to be appending additional digits at the end. For example 1234 is appended as 12344. I have this issue only in Prod environment but not in the development environment. Please advis...
- Sun Dec 14, 2008 10:53 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Input column does not promote to output column
- Replies: 5
- Views: 5361
Input column does not promote to output column
Hi
I am passing 10 column as the input to sort stage and taking the same number of columns as the output.
But in the run time i am getting the error
"Input column does not promote to output column"
Can any one help me in this?
Thanks in advance
Ram
I am passing 10 column as the input to sort stage and taking the same number of columns as the output.
But in the run time i am getting the error
"Input column does not promote to output column"
Can any one help me in this?
Thanks in advance
Ram
- Tue Oct 28, 2008 8:45 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Read more than 1 sequential file
- Replies: 5
- Views: 1685
- Tue Oct 28, 2008 7:26 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Read more than 1 sequential file
- Replies: 5
- Views: 1685
Read more than 1 sequential file
Hi
Can any one suggest which will be the best way to read more than one sequential file? I have 4 files with different name, but with same metadata. Let me know how to read all these files in a time
Regards
Ram
Can any one suggest which will be the best way to read more than one sequential file? I have 4 files with different name, but with same metadata. Let me know how to read all these files in a time
Regards
Ram
- Mon Oct 06, 2008 8:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Clear the rows before inserting depending on non key coloumn
- Replies: 18
- Views: 5993
And also give commit after the DDL stagement. Ram Hi Check the log, for any error message / info? And also check the privilage for that specific user which is beeing used via DS. Regards Ram Hi Sura, I have implimented what you told its not working,its not deleting rows in the target table before in...
- Mon Oct 06, 2008 7:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Clear the rows before inserting depending on non key coloumn
- Replies: 18
- Views: 5993
- Mon Oct 06, 2008 7:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Clear the rows before inserting depending on non key coloumn
- Replies: 18
- Views: 5993
Hi In your input to the DB-->SQL-->Before You can write the custom SQL which will trigger first before the records start to insert. Regards Ram can any one say how can i do it.I did as craig said by marking them as key coloumns but when i hard code them to the values the job aborting, Please can any...
- Mon Oct 06, 2008 5:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reject record with NULL from src loads to a mandatory column
- Replies: 2
- Views: 1502
Re: Reject record with NULL from src loads to a mandatory co
Hi You can try the option like NullToZero(col_name)=0 then Drop the row / what ever you need else xxxx Hope this might help you. Cheers Ram Hi, I like to know if there is a way to drop the record if it comes as NULL from source and we load this record to a column which is defined as mandatory. Curre...
- Sat Mar 22, 2008 9:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error while Generate (Build)
- Replies: 4
- Views: 2571
- Fri Mar 21, 2008 11:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error while Generate (Build)
- Replies: 4
- Views: 2571
Re: Error while Generate (Build)
Hi, Just i removed the input and output port and then Generated. I am getting the below messge. Operator Generation Succeeded buildop -f -BC cxx -BL cxx -FN -C buildop -H buildop -O buildop -W buildop buildop/ReadSeqFile.opd register-library -verbose -registry buildop buildop/ReadSeqFile.dll 1 opera...
- Fri Mar 21, 2008 11:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error while Generate (Build)
- Replies: 4
- Views: 2571
Error while Generate (Build)
Hi, I am trying to develop a stage using New Parallel State Build. While I tried to Generate, I am getting the below error. I understood, the error belongs to input and output port. It will be very helpful, if anyone helps me to resolve this error. Please let me know if there is any good doc for t...
- Thu Mar 06, 2008 10:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join Throws error
- Replies: 15
- Views: 7035
Re: Join Throws error
I am trying to do a join on two oracle tables Datastage 8.0.1 but the job aborts and gives me the following error: Join_97,1: Failure during execution of operator logic. Join_97,1: Input 0 consumed 9 records. Join_97,1: Output 0 produced 9 records. Join_97,1: Fatal Error: Pipe write failed: Broken ...
- Fri Feb 29, 2008 1:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Retrieve deleted job
- Replies: 1
- Views: 925
Retrieve deleted job
Hi,
If a job is deleted in designer can we able to retrieve it back?
Is there is any way or option (like temporary deletion in windows) to get back that job?
Sura
If a job is deleted in designer can we able to retrieve it back?
Is there is any way or option (like temporary deletion in windows) to get back that job?
Sura
- Fri Feb 29, 2008 12:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Concatenation of two tables without having common column
- Replies: 4
- Views: 2208
Re: Concatenation of two tables without having common column
Hi,
Use modify stage to change the column name.
Sura
Use modify stage to change the column name.
Sura