DSXchange

Hi All, We have a Datastage project which has more than 2600 jobs running daily. I have to set the DS_PXDEBUG parameter to 1 at project level for analyzing one job failure. If I turn on DS_PXDEBUG parameter at the project level, would it degrade the performance of all other jobs? Thanks in Advance, ...

Hi

I think the RCP is on at the project level. Disable the RCP and try.

Hi

You can concatenate the date with "00:00:00.000". it will be converted to time stamp.

Hi

it is not possible to assign the current timestamp in the column generator stage. But you can pass the hard coded time stamp (calling any routine and assigning the value to the parameter) using job parameter to the column generator stage. This may help you....


Kiran

Hi Use the DRS stage instead of the Oracle Enterprise stage. this will solve your problem. Kiran Hi , We have got a column(addr_key) in the oracle table which has metadata like Number(11). In the datastage job , we have a query like SELECT MAX(ADDR_KEY) ADDR_KEY , 'ADDR_DIM' TABLE_NAME FROM ADDR_DIM...

How many jobs can access one Data Set for reading at a time?

Can we run jobs from Routines?

Is there any limit for declaring the environmental variables & job parameters?

ds_is_fun wrote:Char to numeric conversion. Any suggestions?

char is left justified and int is right justified.