DSXchange

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...

i using datastage transformer for saving off the values with stage variables and looping based on above..is it way of doing it?

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-...

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

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 ...

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...

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...

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...

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...

Frank,

We are not having issues with FTP, the file is on Engine server. When we try to load into MSSQL server table it is taking more than a day for 67million.
Today we re-tried on v8.7 , it processed within 2hrs.

Thanks Ray.

I tested with Source Sequential File , Target Copy Stage. Even also its reading 80 records per second which will eventually says it will take 30+hrs to process 67Million records.


What else I can check ?

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...

Any help on this ?

Provide your full routine. so that we can assess.

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")