DSXchange

Hi, we are setting up a 11.3 environment on winodws, and planning to use windows AD authentication for datastage. Essentially having same windows network id for datastage and single password for windows and datastage and completely governed by the password policy of the organisation. Is there a doc/...

Yes, that is why our existing env added it, but doing the same on 11.3 windows was throwing a syntax error for \

i meant to have the values passed as 'ABC','DEF' instead of \'ABC\',\'DEF\' and have the env variable set to 1. this preserves quotes. i will try to see without adding the env variable, if passing the entire string ('ABC','DEF') including paren as param value will work. it seems to work with db2 dri...

There is one other way with a code change thoough

instead of IN (#col_values#) just do a IN #col_values in the SQL and pass ('ABC','DEF') at run time.

Thank you, the combo appears to work.

We don't want to do a code modification and do a WHERE COL_NAME IN ('#col_values#') this only works for one value, if we pass multiple values it doesnt work. like ABC works COL_NAME IN ('ABC') but ABC,DEF will not work as it would translate to COL_NAME IN ('ABC,DEF') which results in a inccorect query

Hi We upgraded recently from 8.1 Linux to 11.3 windows. Some of our jobs use ODBC connector to SQL server and we have custom queries. Those queries contain IN operators and the values are passed as job parameters. For example WHERE COL_NAME IN (#col_values#) in run time, we pass \'ABC\' and it trans...

Hi, Can multiple versions of datadirect ODBC drivers co exist on the same datastage server? We have many projects on our server connecting to different databases. Some of our jobs point to SQL Server 2008 and some to ssql server 2012. Our current version of odbc drivers do not support 2012 so we hav...

Thank you.

Many of our sequences use Unix commands to move and archive files. The paths are parameterised. Do you know if the same sequence is exported and imported into a project hosted on DS 9.1 on windows, would the commands work with out modifications if we use MKS Tool kit?

Thank you. the country is US:-) Is there a official documentation from IBM that talks about not using the MKS Toolkit on windows?

We can get support, we already have a production running linux server with DS 8.1. Should the lack of having a commitment to support a linux server outweigh all other benefits of a linux os?

Hi, I am looking for an opinion here for the scenario we are in. We currently have 2 datastage environments 7.5 (running on windows) and 8.1 (running on linux). Since 7.5 is out of support, we have been migrating jobs to 8.1 and modifying the jobs/routines to suit the linux environments(directory pa...

that table that the job hits is pretty huge and scenarios for delete are very few. mostly inserts. identifying the deletes will be costly against this table. at the same time, i dont want the job to try deleting non existent records

Hi In a single job, can this be implemented? Target A. Primary Key is a identity column. Logical/business key is the A1 column. Treat A1 as a set operation. If there is a new set A1, all the existing sets for A1 in the target table need to be deleted and new should be inserted A1,1,23,4 A1,3,4,5 Sou...

I am trying to implement a design where different feeds can provide data with same metadata, but different delimiters and text qualifiers. While I can make the delimiter driven by parameter,I cant do the same with text qualifiers. Is there a way we can dynamically asign the kind of text qualifier at...