DSXchange

Thank You James.

The logic is not very simple in other jobs. The NextValue is used in many places so coding it in DB2 Connector will not solve .

I shall reach to official IBM support . I hope they have some solution to it.

Thanks for reply Andy, sorry but I couldn't understand your statement that zOS DB2 is not supported by DS.

We are running jobs with all the functionality with zOS db2 and its working fine.

Did you mean zOS DB2 Sequence are not supported by DataStage ?

Environments We have two DataStage setups. One for windows and another with AIX. We have two DB2 setup as well One with Windows and another one is withzOS. Job Design Job 1 Seq File ----> Transformer------> writing to multiple DataSets and Updating a Table. Job 2 Dataset --> Transformer --> Lookup ...

Remote deployment -- Remote deployment of parallel jobs allows job scripts to be stored and run on a separate machine from the engine tier host

More detail can be found here.

Contacting IBM.. for this issue , lets see what they have to say !

I was advised by my co-worker to set the $APT_EXPORT_FLUSH_COUNT to 1 . This works fine when I ran the job from DataStage Designer.

But this is not working in remote deployment .

I have created a job which has below design DB2 ----> Transformer --ABRT--> Peek ____________ | ___________Message __________ | ____________Sequential File The Transformer has two links Message and Abort . Message link has no constraint and abort has constraint as CNT <> 1 In Message link I am writi...

Please do provide all information ... like your source type ( Sequential or RDBMS ) Assuming you have a sequential data source After reading the data , In transformer you can put a simple check stagevar --> If ValRecd = "*" then 1 else 0 add a constrain stagevar = 0 this should do it.

I would create a view which have records with max time of database records and perform a left outer join or spars look up .

Hope this will help!

Thanks ArndW ! You nailed it.

As mentioned in previous post ... all input data type is of char ...

Double quotes works like charm with Varchar and char ... it is working in all my previous jobs and other stage variables in this job so that can not be the root cause of this.

Thanks for the response guys ... Here is the erroneous code which causing this issue:- I have a stage variable which has below code .. (All input fields are of CHAR data type . Stage variable is small int ) If Main.INSERT_UPDATE = "U" AND Main.COLLTN_APPL_ID <> LEFT((TRIM(Main.COLLTN_APPL_...

I made few changes in existing compiled job. The changes are 1)Added a new stage variable 2) Added few more if else in existing derivation 3) change in data type from var-char to char for two columns After saving the changes when I compile the job I get below error :- Output from transformer compila...

Make your reference data NULLable so that a NULL can be stored in case of lookup failure.

Please explain more about the nature of data you are aggregating ..

as Ray mentioned there is no need to clear partitions after aggregation ..

Please give detail information about the job .