Search found 57 matches
- Tue Feb 07, 2012 10:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Routine Function
- Replies: 17
- Views: 11300
- Tue Feb 07, 2012 10:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: surrogate key generator
- Replies: 5
- Views: 4454
#1 You have to first generate the .sk file with initial value - you can do this with row generator ----> surrogate key generator stage row generator:- 1 row column- seq data type- integer initial vlue=0 Surrogate key stage:- input column name- seq action- Create and Update Source name- /<full path>...
- Wed Jul 06, 2011 8:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Row into columns
- Replies: 6
- Views: 3835
- Wed Jul 06, 2011 8:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Row into columns
- Replies: 6
- Views: 3835
- Sat Mar 12, 2011 3:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Configuration file error in Datastage
- Replies: 12
- Views: 15613
- Mon Nov 15, 2010 9:41 am
- Forum: General
- Topic: Generic Wrapper Parameter Setup
- Replies: 1
- Views: 2036
- Tue Sep 21, 2010 9:58 am
- Forum: General
- Topic: Before Job SubRoutine to set Job Parameter Values
- Replies: 7
- Views: 8364
- Tue Sep 21, 2010 9:13 am
- Forum: General
- Topic: Before Job SubRoutine to set Job Parameter Values
- Replies: 7
- Views: 8364
- Tue Sep 21, 2010 7:06 am
- Forum: General
- Topic: Before Job SubRoutine to set Job Parameter Values
- Replies: 7
- Views: 8364
Before Job SubRoutine to set Job Parameter Values
Hi, Requirement: Before job subroutine (BASIC) to provide value (come from a shell script) to the Job Parameter of the same Job. Job Parameter <-- Before Job Subroutine <-- Shell script Solution so far: I can call the shell script and get its output value in a variable. Call DSExecute("Unix&quo...
- Thu Jul 15, 2010 9:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Cannot connect to Oracle database
- Replies: 6
- Views: 10018
Does the datastage user have permission to access the library directories ? Yes, dsadm user belongs to dstage group for datastage and oinstall group for oracle access. I did not use dba group because oracle client was installed using oinstall group and hence the oracle libraries are owned by oracle...
- Wed Jul 14, 2010 4:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Cannot connect to Oracle database
- Replies: 6
- Views: 10018
- Wed Jul 14, 2010 4:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Cannot connect to Oracle database
- Replies: 6
- Views: 10018
Cannot connect to Oracle database
DataStage 8.1 Redhat Linux 5 Oracle 10g Client dsenv content: ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1; export ORACLE_HOME LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$APT_ORCHHOME/lib; export LD_LIBRARY_PATH LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib32:$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib...
- Thu Jul 08, 2010 6:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Message Trigger jobs using UNIX
- Replies: 3
- Views: 2346
- Tue Jul 06, 2010 10:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage 7.5.x compilation error for transformer
- Replies: 5
- Views: 4758
- Thu Dec 10, 2009 11:28 am
- Forum: General
- Topic: Oracle Error
- Replies: 13
- Views: 5387
Why you need root priviledge to find and see a file? Locating a file through a FIND command is easier with ROOT login as it does not give you error on Directories that you don't have access to, while searching the file with your user login. Comment was more specific on searching and locating the fi...