DSXchange

Hi,
I'm getting error while i'm moving jobs from versoncontrol to production.
how to move Strcat function from routines to prod.
thanks in advance

Hi ray,
I'm discussing about the adminstration work not devlopers.
In testing server under the batch job there will be some sub folders.
like hash,ftp,log etc....

Hi Ray,
Where to search for that output file name?
In Log folder available in the testing server.Can u be clear

thanks in advance

Hi Ray,
Where to search for that output file name?
In Log folder available in the testing server.

Hi AndreW'
Thanks for ur reply

Hi Arndw,
I'm checking datafiles in FTP server. I need to search the output file name from the job.

Hi Arndw,
I'm checking datafiles in FTP server. I need to search the output file name from the job.

Hi, Thanks for your response.I'm working on deployment.I test the jobs in QA server(Testing server).Jobs are successful. I want to login to the ftp sever and check if the data files successfully loaded are not. For that i have to know the name of the output files being FTPed. Where and how can I fin...

Hi,
Can any one help me in finding a path of the server job.My job is stored in a FTP server say X.How to find the path of that particular job stored in FTP server?

Hi, I have problem with the dynamic value to be specified in where condition is (@zMonth , @zYear ). So how do we support dynamic values of SQL query in datastage ODBC STAGE? Is there any way apart from specifying in parameters. SELECT tb_eps_comp_month.[emp_prod_id], tb_eps_comp_month.[zYear], tb_e...

Hi Ray, First of all i'm sorry. i'm doing the deployment.Running the batch jobs(adminstrative work). Once the devloper finished devloping the jobs puts in version control.That jobs i will promote it to QA server for testing.Run in dos prompt.While running the jobs i'm getting this fatal error in dir...

Hi, I'm new to the deployment,can any one help me in resolving . I'm getting the fatal error in QA box mq3_401k_step03..Stg_401k: [IBM][CLI Driver] CLI0106E Connection is closed. SQLSTATE=08003 [IBM][CLI Driver] CLI0108E Communication link failure. SQLSTATE=40003 SQLSetStmtAttr: Failed to set row ar...

This is the fatal error i'm getting


mq3_401k_step03..Focus_File.F_in: read_delimited() - row 1, column FC_NM, required column missing

Thanks Ray,
If u won't mind can u help me how to resolve this.

Hi,
In job deployment QA box,

i'm getting the fatal error column missing.How to resolve this pls help me.

Advance thanks