DSXchange

Hello friends,

We use Espresso to schedule all our jobs by triggering them via shellscripts.The problem is that the passwords are appearing in clear text in the logs of Espresso.
Is there a way to encrypt passwords when triggering the jobs through shellscripts?

Thanks a lot in advance
Yamini

Hi Kris,

I got the same error (ORA-01722: invalid number) even after using NumericIsSigned function
This is how I used the function in the Transformer
NumericIsSigned(inLink.EMPR_ID)

Did I use the function incorrectly?
Can someone please help me with this?

Thanks
Yamini

Hello friends, I am getting the following error when I tried to transfer data from a VARCHAR field to NUMBER field "ORA-01722: invalid number" Is it possibe to convert the data (similar to to_number() function) using a particular function in DataStage? Any help would be highly appreciated ...

Hello friends, I am getting the following error when I tried to transfer data from a VARCHAR field to NUMBER field "ORA-01722: invalid number" Is it possibe to convert the data (similar to to_number() function) using a particular function in DataStage? Any help would be highly appreciated ...

Hi ArndW,

You are right. When I calculated the length, the field is showing the correct length as in source.
Can you please through some light on the issue of the padding of the field?

Thanks
Yamini

Craig,

Can you please answer the following questions?

1) Does DataStage store characters with special characters differently than the database
2) Does DataStage reduce the field length whenever it finds a special character in the data?

Thanks lot in advance
Yamini

Hi Craig,

The DataStages' NLS is defaulted to ISO8859-1 and the installation is NLS enabled.
We are using Oracle 9i database and I am not sure about the default character set of the db (I think it would be UTF8)

Thanks
Yamini

Hello Ray,

The following is the second last entry in the log of the sequence
Job control process (pid 20162) has failed

I think this occured after I killed the process as it was not doing anything

Also, can you please tell me how I can find the InvocationID of the job?

Thanks
Yamini

Hello there,

The problem occured again
The job does not have any before/after sub routines. Also, &PH& directory is not empty and I found only two files in the directory (.Type1 and .uvnlsmap)

Any idea of whats causing the problem

Thanks a bunch in advance
Yamini

Apart from collecting the Statistics we did not take any action to solve the issue

I have requested the DBA to Analyze the table and collect the Statistics

Hello all,

Thanks a lot for your suggestions...
Analyzing the table did the trick

Yamini

Hello friends, I am running into issues while running a simple Server job. The job inserts data into an Oracle table reading from a Seqeuntial File Stage. SequentialFileStage==>Transsformer==>OCI9i Stage When I tried to execute the job for the first time it did not insert any records ever after runn...

Hi Ray,

Can you please tell me how I can access &PH& directory?
I tried to enter the directory and got the following
[dstage@DSEngine]$ cd &PH&
[3] 28082
[4] 28083
-bash: PH: command not found
[3] Done cd

Thanks
Yamini

Thanks a lot for your suggestions.
I am waiting for the scenario to reoccur so as to get more information

Yamini