DSXchange

Hi Wesl

I knew this link , i don't feel confortable running the CLEAR.FILE &PH& command (because it's not clear to me) and like Chulett is't about tree jobs in a project.

Thank you anyway.

Hi gurus We are facing the following issue: some jobs are staying "running" in the Director. When we check the monitor all the stages are green and in the log we can see the sequence main program finished "Ok". On the server a process usvh is present. What is your advice? Thank y...

Hi guru We want to delete the dataset withing a job using orchadmin del -f /directory/*.ds. When the job run we have those warnings Item #: 17 Event ID: 16 Timestamp: 2014-05-21 13:09:28 Type: Warning User Name: XXXX|XXXX Message Id: IIS-DSEE-USBP-00002 Message: Suppression_DATASET,0: ##I IIS-DSEE-T...

Hi gurus One of my teammate report me a "bug" in the GetEnvironnementVariable routine. The commande Call DSExecute("UV", "ENV", Output, ExitStatus) does not retrieve all the Environnement Variable (ex APT_CONFIG_FILE). My verification does not work for parallel job. Tha...

Hi all
I just find this
JR46185: DB2 API PLUGIN THROWS INVALID WARNING MESSAGES REGARDING DATA TRUNCATION on the Ibm website.

It's fix pack for the 8.5 do you know if a fix exists for the 8.7 version ?

Thank you.

I try to clarify
In my db2stage i have this The lenght are correct , the stage writes a warning on COL1 (20) saying that it would be 38 which it's wrong.

In the database COL1 is really 20 not 38 , the 38 belong to the previous column of the table .
So 8.1 is correct and 8.7 is wrong.

I think you misunderstood me .(maybe it's me)
The job is right , the metadata were imported from the database.
In 8.1 the job doesn't produce any warning because everthing is allright.
In 8.7 we got a warning without modift anything.
I can't change all the columns of all the job after the import.

It's a server job.
This behavior is very annoying because it stops our migration process.

We are not doing any transformation ,the job is very simple (a select from a table
The warning appears while reading the database.

Hi All We just achieved the installation of Datastage 8.7 on a brand new server. When we performed our test of installation we got this warning : The size specified for column 'Col1' (20) is less than that of the source table column (38);data truncation may result. This happens using the old db2 con...

Ray I found the GetEnvironmentVariable routine that you wrote.
It works fine except for the variable with the encrypted type.
The routine give me the encrypted value which i can't use to connect to my database.
Is there a way to decrypt it ?

Thank you

Chulett unfortunately i can't read the premuim content. Here is what i do : After reading an ini file who contain : $My_DB=$PROJDEF I got exactly the same thing in my job control. When i use dssetparam(jh1,My_local_DB,$PROJDEF) then $PROJDEF is not set to environnment value but stay '$PROJDEF'. The ...

Hi all
I would like to pass the $PROJDEF keyword between a job control (in basic) and ordinary jobs.
None of them have environnement variable and the result is that the $PROJDEF is never changed to "real" value.
Do you know a way to force the evaluation of $PROJDEF ?

Thanks fof helping.

Hi All
I'm wondering how datastage handles the tempory "files" if the uvtemp parameter is not set in the uvconfig file.
Thank you.