DSXchange

Search for the exact error message and you will find the solution. Although I suggest looking at file closely as it says ,it is unable to find the record delimiter to ensure the delimiter is present only after the 100000 bytes . For trailer records , the sequential will reject the record automatical...

Apologies Craig.
I Should have pointed towards it.

Set this environment variable APT_IMPORT_PATTERN_USES_FILESET to true and check.

Not an expert , but this is how we had done it. Since the OS is mentioned as UNIX. A while loop with a condition for controlling the start and stop of the loop. In the while loop , check for the existence of the trigger file ,if present run the job using the dsjob command else some wait time to rech...

Search the forum for Ignoring duplicate entry at table record If the reference set is expected to have multiple records and you are expecting multiple lookup results , then enable return multiple rows in the lookup. Else de duplicate the data using a remove duplicate stage. If you have capture the d...

See if this helps.

viewtopic.php?t=146613

The filename can be read in the sequential file stage using the filename column.

chulett wrote:That would be a PX answer. For a Server job, create a routine that leverages DSExecute() and call that in your transformer. ...

Sorry missed the forum.

There is an external filter stage where you can use unix commands which operate on each row.
Not sure if you can call a script there.

This link tells you about the compilation of your code.

http://www-01.ibm.com/support/docview.w ... wg21607302

Thanks,
Chetan.C

Hi,

For the ACCT=100 the max recno is 11 and name is NULL not bb.
Any chance this is not being handled, to give the not null value causing the issue?

What is the RECNO that you are getting in the output for that ACCNT?

As craig said, do show us the stage variables.

Thanks,
Chetan.C

Hi,


Create a folder "SampleJavaPlugIns" in the directory of your present class file location.
Your class file should be present inside the "SampleJavaPlugIns" folder.




Thanks,
Chetan.C

Hi,

In the beginning of the code,can you show us what is the package and class you are pointing to.

Like this.. http://tinyurl.com/d8sgf6n.


Thanks,
Chetan.C

Hi,
Another option would be to use the Terminator Activity.
Based on the condition the flow can be directed towards the terminator activity.


IBM docs.
http://tinyurl.com/czfdh82.


Thanks,
Chetan.C

Oops!!
Thanks Shane.That was the problem.

Hi, Im trying to read a date column in sequential file stage. The date format string in the extended properties of the column is specified as: %(d,s)/%(m,s)/%yyyy I'm able to read date like 1/1/2012 but with same format I'm unable to read the date like 12/31/2012 . The output appears like this *****...