DSXchange

Ray, I think this is the only option available. I will try this.

Thanks all for your suggestions.

Hi,

The vendor asking us to remove the spaces for decimal field. Since its a generic job i am not able to remove space. Any work around which you can help me with.

Regards,
Aks

Hi All, I have created a generic job which reads the data from Teradata and creates a flat file. The SQL i am placing in a file in unix and passing as a parameter to parallel job. For the decimal columns in flat files, the values are starting with one blank space followed by decimal value. Example: ...

Hi, As you mentioned its a multi instance job, whenever you run the job the will run with invocation id. It will be considered as separate job, since the initial status of job is compiled hence it is 99. Try running job without invocation id and check the status, it will be different. Hope this helps.

Could you please help on this?

Hi,

Tried, still same error.

qt_ky wrote:Does your engine run on the default port?

yes.

PaulVL wrote:do any other dsadmin commands work?

yes, it does.

Hi Paul,

It has the same value which you mentioned, but still getting the same error.

Regards,
Aks

Hi Ray, I tried, its the same issue again. dsadmin -domain dstagesbox:9443 -user dsadm -password ********-server engine -createproject test_project -location /data/projects/test_project/project ERROR: java.rmi.RemoteException: Connection to https://dstagesbox:9443 refused; nested exception is: org.a...

Hi, I am trying to create a project with dsadmin commad but it is failing. Details: DataStage Version:11.3 Platform: Linux. dsadmin -domain serviceshostname:9445 -user dsadm -password ******* -server enginehostname -createproject test_project -location /data/projects/test_project/project ERROR: java...

Use

Ereplace(Execute_Command_0.$CommandOutput,@FM,'' )

chulett wrote:Quotes in parameters are known to be stripped, you need to escape them to protect them. Typically a backslash would work, try that first. ...

Thanks Craig!!

hi, i have a sql query for ex: select col1,col2 where col1='a' and #para1#.. in the above sql the parameter #para1#=END_DT = to_date ('9999-12-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS'). while execting the job it is throwing "Unrecognized argument: 23:59:59 " fatal error. can anyone suggest me...

Hi,

How can i generate surrogate keys without using surrogate key generator stage in datastage??

Regards