DSXchange

Hi, I am creating a job in which I need to use an iteration. The job I have has a seq. file with one row of data, two transformers and im mapping to a table using db2 connector. In the first transformer, I have the columns mapped to what the table looks like. The second transformer will have a loop ...

I mentioned this to see if it would have any effect on the performance. We will be running tonight to see if it persists. Thanks for your help.

The SQLCODE is 40506, Native Error Code is -1,476, Error code -911. Our architect wants us at 2000 array count

Hi All, I am having an issue with a parallel job within a sequence that will fail after the first run and then, when restarted, it works fine. I am getting the fatal error "DB2_Connector_18,0: An insert, update, or delete statement failed to run. (CC_DB2DBStatement::processRowStatusArray, file ...

Hi All, I am working with 2 tables to update 1 of them. I have my Address table and Key table. They both have common columns named CLient ID and ODS_ClientID. The Key table populates ODS_ClientIds and I want to update them in the address table. So for every client id in the address table, there is a...

So when I took the hyphens out and made it %yy, I will get an error and fail if the 20 is still in there. The testing scenarios are: PROVIDER20160602 PROVIDER2016-06-02 PROVIDER160602 PROVIDER16-06-02 PROVIDER2016602 PROVIDER2016-6-02 PROVIDER2016062 PROVIDER2016-06-2 PROVIDER201662 PROVIDER2016-6-2...

Hi, I am receiving a file and there is a Header that states PROVIDER20160602. I am to take out the date an insert it into a row in a table. I am using the function StringToDate( Link_INBND_TB.G_NYMMIS_HDR_DT,"%yyyy-%mm-%dd"). Now when a file says PROVIDER160602, without the 20, I am gettin...

Hi, I am trying to execute a db2 stored proc using Stored_Procedure stage in a parallel job. I am using below steps sequential file---->transformer------->stored procedure stage I get in call to ORPHCallActivePluginInitialize() error. Couldn't figure out the reason/solution on this issue. warning: S...

Hi, So I created a custom trigger in the execute command stage "JobActivity.$JobStaus = 'Executed OK'. This deletes the file when the job is done running. I have a problem, however, when I put an error in the job to abort it... The job still deletes the file. What should the proper syntax be to...

Thanks for the info. I am going to read this info

http://i.imgur.com/zNoeW6y.png So I went ahead and added the Execute Command stage (number 2) with the command 'rm' and the parameter is the filepath of the sequential file. At number 1, the trigger is currently Unconditional, meaning Expression 'N/A'. What would need to be added to this, if anythi...

Hi, I am trying to see if it is possible to delete a sequential file during/after my run of the job? I have 2 sequence jobs and 4 parallel jobs. The 1st sequence job is where I am extracting the sequential file and it gets passed to the 2nd sequence job which will trigger 3 parallel jobs (the 4th pa...

So an update... In the job activity with the parallel job taking a number from the ODBC, I used SQL for a max function. But I am now using a transformer and remove duplicates to retrieve the max function. The trans and RD work to get the value to the file but the sequence job fails. Without the 2 ne...

Starting loop is a list loop, comma delimited with the CommandOutput from a command execute stage that reads multiple files

The job worked fine yesterday from early morning til 4pm and then the error started occuring. I have 2 parameters , 1 is string and the other is integer. I think it is for the integer because my datastage job creates a file with an integer value, cat command is used in execute command to pass that i...