DSXchange

Within a transformer, I had to define a long IF ELSE IF statement in the derivation section. I've encountered the following error while compiling the job: Compiling: Source = 'RT_BP760/JOB.2125494777.DT.1344463330.TRANS5', Object = 'RT_BP760.O/JOB.2125494777.DT.1344463330.TRANS5' *******************...

Within a transformer in a parallel job - we have mapped columns between the input and output links, however, some of the links are still marked red. The datatype and length are the same between the two columns. What are some of the typical reasons why the columns are invalid?

I am still new to DS...how do I create user defined routine?

Thanks!

I want to extract data from a sequential flat file and then load the data into an Informix database. Is there a way I can check to ensure the data types integrity from the flat file before passing it through to the database? I understand you can create a constraint in the transformer to reject any r...

I want to extract data from a sequential flat file and then load the data into an Informix database. Is there a way I can check to ensure the data type integrity from the flat file before passing it through to the database? I understand you can create a constraint in the transformer to reject any r...

Does all BASIC functions work in SERVER and PARALLEL job?

I was able to create a Change() function in a Server job, but it was not recognized in a Parallel job.

How do we know which functions work in Parallel???

Is there a built-in function that captures when the job start and end?

Thanks!

I am creating a PARALLEL job that take data from sequential file, pass it through a transformer and puts it into an Informix database. The transformer also contains a link to a sequential file that captures all the rejected records. I need to create a sequential file that gets the job name, start ti...

What is the setnet32? How and what do I check for? The job fails all together.

I am creating a job that take data from sequential file, pass it through a transformer and puts it into an Informix database. The transformer also contains a link to a sequential file that captures all the rejected records. I need to create a sequential file that gets the job name, start time of jo...

QUESTION 1 I have created a job that grabs data from a sequential file and through a transformer, outputs to an Informix database via the Informix CLI stage. I am having problems viewing the data (Note: the job does not run successfully due to the same error). The error I've received when I click o...