DSXchange

Anyways, glad its working as you required

The job should have aborted as per the below link.
Even I tried it out, it just logs a warning.

http://www-01.ibm.com/support/docview.w ... wg1JR36642
Thanks,
Chetan.C

As I feared this will not work. i get the message: ECHO is not really a command that goes here. In your .sql file at the beginning you must include the whenever sqlerror exit sql.sqlcode echo $? does not come in the .sql file. By script I meant the Unix script. There is a shell script in which you ...

...and that is exactly what I do not know how to do. Include this in the .sql file whenever sqlerror exit sql.sqlcode Above can also be customized like whenever sqlerror exit 67 This returns the number of the associated Oracle error. In the script echo $? Gives the return code of command executed ,...

Hi, This code will abort the job if there are no files found. if ls #path#/REPO.*.2012-07-11*.txt >/dev/null 2>&1;then cat #path#/REPO.*.2012-07-11*.txt |sed '1d:$d';else exit;fi The better way would be as Shane suggested ,not to trigger the job itslef if file is not found. Thanks, Chetan.C

Chetan.C tells us that the table design has yet to be defined. I think that doing that is the absolutely vital first step - what information about data errors does Chetan.C need to capture? :) Well , Chetan.C has been asked to see how best he can be showing the data without any specification as to ...

chulett wrote:Sure, I've seen them too. But more interested in what our friend Chetan.C has to say on the subject. It's their table after all. ...

I did ask the same question , and the answer was "what's way the best way we can be showing this ?" ... so decided to give it a try.

Hi, I have 3 Oracle Tables with different schemas. Each table has a reject link and the rejected records are captured in a Sequentail file. The rejected records need to be captured in a target table whose definition is not yet defined as it depends on how we can capture these records. Kindly let me ...

Just encrypted the password and used it in the job.Its working fine.
Thanks Arnd and Ray.

Thanks Ray.
I'm currently using it to encrypt the Datastage password.
Will extend it to the DB password too.

Thanks,
Chetan.C

Hi,

I would like to know what is the best practice to securely pass the DB password to a job.

Currently I have it defined as Environment variable(encrypted).
Is this the best way to do it?

All the other required parameters are fetched from the table.

Thanks,
Chetan.C

For the first question, you can concatenate the ".txt" to the filename column within a transformer. The code does this. field1=index($0,","); Find out the position of "," which I'm assuming as the delimiter between Filename and the record($0 the entire row). substr($0,f...

...capture each data seperatly in respective file given below also there order should be retrieved as it present in input file Hi , Had found this on dsxchange itself. In a parallel job use an External_target stage and use the below code in the program box. cd /your_directory;awk '{field1=index($0,...

...add $APT_STARTUP_STATUS and $APT_PM_PLAYER_TIMING to your job set to True in both environments. Compare and contrast. ... Hi Craig, I added the 2 environment varibales $APT_STARTUP_STATUS and $APT_PM_PLAYER_TIMING to the job and this is the pattern I found for all DB look up tables. Environment ...

Hi, Its been a long time but we have a work around for this. We raised a PMR for this, the reply that we got was its "normal" for Datastage to take the extra time to load XMETA libraries etc. What we did was to use an external source stage for this and dumped a portion of the Unix script t...