Search found 56 matches
- Thu Jun 04, 2020 8:59 am
- Forum: General
- Topic: Creating packages for objects with istool
- Replies: 7
- Views: 16777
Creating packages for objects with istool -adding components
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 &...
- Thu Nov 19, 2015 11:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Running job with multiple parameters
- Replies: 8
- Views: 9598
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...
- Wed Nov 18, 2015 5:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Running job with multiple parameters
- Replies: 8
- Views: 9598
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 ...
- Mon Nov 16, 2015 9:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Running job with multiple parameters
- Replies: 8
- Views: 9598
Running job with multiple parameters
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...
- Mon Jun 23, 2014 1:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SQL server connector stage issues
- Replies: 1
- Views: 2214
SQL server connector stage issues
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...
- Wed May 29, 2013 7:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: To get the output for counting the occurence of the rows
- Replies: 3
- Views: 3805
- Wed May 29, 2013 7:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: To get the output for counting the occurence of the rows
- Replies: 3
- Views: 3805
To get the output for counting the occurence of the rows
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
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
- Thu Oct 18, 2012 3:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Field delimiter missing for null data
- Replies: 2
- Views: 2911
Field delimiter missing for null data
Thanks Rob. we will try this option.
- Tue Oct 16, 2012 8:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Field delimiter missing for null data
- Replies: 2
- Views: 2911
Field delimiter missing for null data
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. ...
- Wed Jun 27, 2012 6:41 am
- Forum: General
- Topic: Moving from AIX to LINUX
- Replies: 2
- Views: 3074
Moving from AIX to LINUX
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...
- Fri Feb 10, 2012 6:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: error loading DB2 table using ODBC stage
- Replies: 5
- Views: 4517
error loading DB2 table using ODBC stage
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...
- Sun Jan 15, 2012 5:25 pm
- Forum: General
- Topic: Parameters values not passing properly
- Replies: 1
- Views: 2067
Parameters values not passing properly
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...
- Wed Sep 14, 2011 10:57 pm
- Forum: General
- Topic: Unable to run sequencers
- Replies: 2
- Views: 2384
Unable to run sequencers
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...
- Sat Sep 10, 2011 2:01 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage server edition & Salesforce.com(SFDC) connecti
- Replies: 6
- Views: 8642
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...
- Sat Sep 10, 2011 1:29 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage server edition & Salesforce.com(SFDC) connecti
- Replies: 6
- Views: 8642