DSXchange

Hello All amit.jaiswal_ATL - there is not much documentation for istool create package option, the syntax you mentioned worked perfectly fine for creating a new package and adding jobs to it, Thank you I could not find out options related to adding a new job once a package is created or created &...

Thanks all for inputs, we created a routine to read the parameter value file and get the value from it for required parameter. when calling a job, in the sequencer job parameters mapping section, routine will be called by passing paramfile name and parameter name, so return value(in my case new uniq...

Thanks Chulett, Ray and Naveen. I have combined the approach mentioned here, we are maintaining source credentials in a database table and we created a one time job to populate the parameter set value files, I am able to pass the required value files at the run time, we want to maintain credentials ...

Hi All I have a job with four main parameters: DB2 DSN, User, Schema and Password. they are set as environment variables and I am reading it in the job, the job extracts data from one of the database tables and writes to a dataset file. I have a requirement to run the same job with in the same Datas...

Hi, We have a job that inserts data into SQL server from a dataset. There is a reject link to capture all rejects if any. The options in the connector stage are below. Table action : Truncate Mode: Insert Generate sql at run time: Yes. The job is running on 4 node configuration. When i run the job w...

Can u please elaborate how we can use stage variable for getting this kind of output, im a beginner in datastage. Thanks in advance

Hi all,
I want to get the following as output from the input provided.

input:-
a
a
a
b
b
c
d
d
d

output :-

a 1 1
a 1 2
a 1 3
b 2 1
b 2 2
c 3 1
d 4 1
d 4 2
d 4 3

Kindly suggest

Thanks Rob. we will try this option.

Hi, We have a job which reads data from legacy tables and create a xml file. Xml payload part is a concatenation of all the input columns with pipeline as field delimiter. Also we are using NullToEmpty() function in transformer stage before xml output stage to convert all the nulls to empty string. ...

Hi, We have Datastage currently installed on AIX. It is interacting with SAP, Oracle and Flat Files. We are planning to move from AIX to Linux environment. The Customer is asking for an estimate for this migration. Can you help me out in giving a rough estimate Admin Tasks to a) Install the Datastag...

Hi, I have a requirement to update a Db2 table, i am using ODBC stage to perform this update, I need to handle rejects and so i am using ODBC stage to do it as this stage can capture the rejects, When trying to update, the job fails with below error message APT_CombinedOperatorController(2),0: Fatal...

Hi All, I Have Sequence name A_Seq, it calls a job called A_job. We defined all the our database connections, user names and passwords in the environment variables and passing them to the Parameter set A_parm. There are three environments development, testing and production. Hence created three valu...

Hello Experts We created a new project , imported and compiled jobs from development as well. While running the sequence , we get the following error SeqScheduler.DWH_ONE.JobControl (fatal error from getParamAndRun): Aborted : Unauthorised Datastage Project Name. Expected project Name for this insta...

Hi, I wanted to connect to Salesforce dot com(SFDC) site using datastage server edition and I want to perform Upsert /retrieve operations to/from SFDC . I am having data in a .csv file. But initially trying to perform different operations using sample data. I am able to use login operation on SFDC w...

ray.wurlod wrote:Look at Web Services Transformer stage.

This has also not solved the problem.Can anyone suggest something else ?