DSXchange

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...

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...

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

ray.wurlod wrote:Use a Sequential File stage with a Filter command that turns all four files into a single bytestream, for example cat file1 file2 file3 file4 ...

Hi Ray

In that case what should i need to give in the File name ?

Regards
Ram

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

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...

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

dsdevper wrote:Hi Sura,

I have implimented what you told its not working,its not deleting rows in the target table before inserting.

Thanks

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...

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...

ArndW wrote:Are you assigning values to the out0 structure?

I would try to do a dummy BuildOp which just duplicates the input to the output and see if you can get that to compile and run. ...

Hi,

No, i am not assigning value to out0

Sura

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...

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...

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 ...

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

Hi,

Use modify stage to change the column name.

Sura