Search found 226 matches
- Mon May 13, 2019 2:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: NEED LOGIC IN DATASTGE
- Replies: 2
- Views: 3151
NEED LOGIC IN DATASTGE
Team i need help in below logic ID EFF_DT END_DT NR_DAYS DEPT TYPE 1 2018-01-01 2018-01-06 5 A CONTRACT 1 2018-01-07 2018-01-17 10 B CONTRACT 1 2018-01-18 2018-02-17 29 C FT 1 2019-01-01 2019-01-07 6 D CONTRACT 1 2019-01-08 2019-01-17 9 E FT Out put needed ID EFF_DT END_DT NR_DAYS DEPT TYPE 1 2018-0...
- Thu Dec 06, 2018 7:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need help in the logic
- Replies: 6
- Views: 4700
- Wed Dec 05, 2018 8:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need help in the logic
- Replies: 6
- Views: 4700
Need help in the logic
Need help in below topic input data Col1(Timestamp) Col2(timestamp) 2017-12-31 10:05:06 | 2017-12-31 10:05:06 2018-01-01 07:20:05 | 2018-01-01 07:23:05 2018-01-01 07:22:05 | 2018-01-01 07:25:05 2019-01-01 06:00:04 | 2019-01-01 06:00:05 output needed 2017-12-31 10:05:06 | 2017-12-31 10:05:06 2018-01-...
- Thu Nov 10, 2016 9:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Write to excel with password protected mode
- Replies: 4
- Views: 8183
Write to excel with password protected mode
Hi Team,
is it possible to create excel file with password protected. i know we can read password protocted excel with unstructured stage but while creating excel with unstructured stage not having options to create with password protected.
Anyone knows about it
Thanks in advance
is it possible to create excel file with password protected. i know we can read password protocted excel with unstructured stage but while creating excel with unstructured stage not having options to create with password protected.
Anyone knows about it
Thanks in advance
- Tue Oct 06, 2015 2:07 pm
- Forum: General
- Topic: Making some components in Dev Environment as Read-Only
- Replies: 4
- Views: 3212
Thanks Paul I changed the permissions to 640 on the value files of the parameter sets and parameter Set and observed that dsadm id is not able to access that parameter set while running the job. So I changed it to 740. Now the job executes fine but import is also successful on the parameter set. We ...
- Mon Oct 05, 2015 10:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Custom BuildOp Stage Deploy
- Replies: 1
- Views: 2516
Custom BuildOp Stage Deploy
Hi All, We currently are on 7.5.3 and planning to Upgrade to 11.3 We have a few Custom BuildOp stages and my question is when we migrate the jobs using this stage, does it automatically get deployed along with the job or are there additional specific steps we need to take to have these Custom stages...
- Sun Oct 04, 2015 9:24 pm
- Forum: General
- Topic: Making some components in Dev Environment as Read-Only
- Replies: 4
- Views: 3212
Making some components in Dev Environment as Read-Only
Hi, We have a requirement where we need to make some components in our development environment as read-only. E.g. some parameter sets, shared containers etc. I tried exporting these codes from higher environments and importing in development environment by changing the read-only flag in the dsx. But...
- Thu Oct 01, 2015 9:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parameter Set Changes - Deploy
- Replies: 2
- Views: 2573
Parameter Set Changes - Deploy
Hi All, We currently have 3 Parameter Sets and they have been deployed to UAT as part of the first release. Now as part of second release we have added a couple of New Parameters to one parameter set, say PARAM1 Value Files DEV - DEV_PARAM1_VAULE UAT - UAT_PARAM1_VALUE Now when we deploy jobs to UAT...
- Thu Sep 24, 2015 2:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parameterize Fastname in APT Config file
- Replies: 2
- Views: 2751
Parameterize Fastname in APT Config file
Is there a way where we can parameterize fastname in apt config file based on the server name on which the DS job is running? I tried using uname -n in the fastname "" but it does not seem to be working. Even assigning a variable the value of uname -n and then recalling it also does not wo...
- Tue Jul 21, 2015 2:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential file performance issue
- Replies: 10
- Views: 7206
- Tue Jul 21, 2015 7:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential file performance issue
- Replies: 10
- Views: 7206
- Mon Jul 20, 2015 3:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential file performance issue
- Replies: 10
- Views: 7206
Sequential file performance issue
we have a sequential file FTP from mainframe contains 67million records. Target is MS SQL server 2008. In v8.7 datastage, the job took 1hr 50 minutes. We recently upgraded to v11.3.1.1 and the job is taking 29hrs. We checked the UVCONFIG file etc every thing is similar and v11.3 box is having bigger...
- Mon Jun 29, 2015 7:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Bulk Load issues inTeradata
- Replies: 1
- Views: 2291
Re: Bulk Load issues inTeradata
Any help on this ?
- Fri Jun 26, 2015 8:20 am
- Forum: General
- Topic: Sqlplus cmd not returning control back to Routine
- Replies: 4
- Views: 2831
- Thu Jun 25, 2015 12:55 pm
- Forum: General
- Topic: Sqlplus cmd not returning control back to Routine
- Replies: 4
- Views: 2831
Re: Sqlplus cmd not returning control back to Routine
OsOutput will store the return value of query. You need to map this to another variable.
like
QueryResult = TRIM(FIELD,OsOutput,@FM,3))
YOu can pass this value to log
Call DSLogInfo("Result:":QueryResult, "JobStats")
like
QueryResult = TRIM(FIELD,OsOutput,@FM,3))
YOu can pass this value to log
Call DSLogInfo("Result:":QueryResult, "JobStats")