Ray, I think this is the only option available. I will try this.
Thanks all for your suggestions.
Search found 16 matches
- Tue Sep 27, 2016 5:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal conversion
- Replies: 6
- Views: 3348
- Fri Sep 23, 2016 12:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal conversion
- Replies: 6
- Views: 3348
- Fri Sep 23, 2016 9:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal conversion
- Replies: 6
- Views: 3348
Decimal conversion
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: ...
- Thu Aug 06, 2015 6:11 am
- Forum: General
- Topic: Sequence status is 99
- Replies: 18
- Views: 11293
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.
- Mon Jun 08, 2015 6:02 am
- Forum: General
- Topic: DataStage: dsadmin createproject command
- Replies: 13
- Views: 8117
- Sun May 24, 2015 10:59 am
- Forum: General
- Topic: DataStage: dsadmin createproject command
- Replies: 13
- Views: 8117
- Thu May 21, 2015 9:17 am
- Forum: General
- Topic: DataStage: dsadmin createproject command
- Replies: 13
- Views: 8117
- Thu May 21, 2015 9:15 am
- Forum: General
- Topic: DataStage: dsadmin createproject command
- Replies: 13
- Views: 8117
- Wed May 20, 2015 11:36 am
- Forum: General
- Topic: DataStage: dsadmin createproject command
- Replies: 13
- Views: 8117
- Mon May 18, 2015 1:28 am
- Forum: General
- Topic: DataStage: dsadmin createproject command
- Replies: 13
- Views: 8117
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...
- Thu May 14, 2015 7:55 am
- Forum: General
- Topic: DataStage: dsadmin createproject command
- Replies: 13
- Views: 8117
DataStage: dsadmin createproject command
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...
- Fri Sep 02, 2011 7:27 am
- Forum: General
- Topic: Getting error in $CommandOutput
- Replies: 11
- Views: 6573
- Wed May 18, 2011 5:18 am
- Forum: General
- Topic: partial SQL query as a parameter
- Replies: 2
- Views: 2166
- Tue May 17, 2011 2:16 am
- Forum: General
- Topic: partial SQL query as a parameter
- Replies: 2
- Views: 2166
partial SQL query as a parameter
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...
- Wed Mar 09, 2011 5:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Alternative way to generate surrogate keys
- Replies: 2
- Views: 2790
Alternative way to generate surrogate keys
Hi,
How can i generate surrogate keys without using surrogate key generator stage in datastage??
Regards
How can i generate surrogate keys without using surrogate key generator stage in datastage??
Regards