Search found 36 matches
- Wed Sep 24, 2014 1:37 pm
- Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- Topic: How to export using ISDImportExport.sh using -omitPassword
- Replies: 1
- Views: 6224
How to export using ISDImportExport.sh using -omitPassword
I am trying to export a runtime application using -omitPassword. Here is my scenario; - Have a ISD service job with DB_connection and DB_password values are setup in user environment variable and those parms are set to $PROJDEF in Job Properties Parm of the job. - When the job is deployed in Develop...
- Wed Sep 03, 2014 9:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How do I Restructre a Table
- Replies: 2
- Views: 2713
How do I Restructre a Table
I am trying to restructure my input table. In another word the table's input columns will be the table's output rows. Suppose I have the following INPUT table: col1 col2 col3 ==== ===== ===== 1 STEVE 10.00 4 RON 15 and would like to restructure that INPUT table to the following OUTPUT table; col_nam...
- Mon Jul 21, 2014 1:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Passing parameters to PL/SQL while in a Sparse Lookup
- Replies: 5
- Views: 6348
- Mon Jul 21, 2014 10:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Passing parameters to PL/SQL while in a Sparse Lookup
- Replies: 5
- Views: 6348
- Wed Jul 09, 2014 10:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parm format passing to sql (using SPARSE lookup)
- Replies: 12
- Views: 9326
- Fri Jun 20, 2014 3:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parm format passing to sql (using SPARSE lookup)
- Replies: 12
- Views: 9326
- Fri Jun 20, 2014 2:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parm format passing to sql (using SPARSE lookup)
- Replies: 12
- Views: 9326
Using ORACLE CONNECTOR-- Added $CC_MSG_LEVEL=2, I get the query but cannot determine how it substitute the variable (another word does not list the query with the value of in_year at the run time) Here is what I get in director; DEBUG:Preparing statement: select year, month from table_01 where year ...
- Thu Jun 19, 2014 1:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parm format passing to sql (using SPARSE lookup)
- Replies: 12
- Views: 9326
- Thu Jun 19, 2014 1:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parm format passing to sql (using SPARSE lookup)
- Replies: 12
- Views: 9326
stuff I dynamically created the input_year as per instruction above and the result was the same. Here is the peek result; Peek_1,0: in_year:'2012','2013','2014' year:NULL month:NULL - (in_year) is the dynamically created string - (year) is coming from table reference - (month) is coming from table ...
- Wed Jun 18, 2014 2:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parm format passing to sql (using SPARSE lookup)
- Replies: 12
- Views: 9326
Parm format passing to sql (using SPARSE lookup)
I am trying to run a query, listing salary by the year. Suppose I have the following query and would like to construct a DataStage job to do just that (with the same query) select year, salary from dept_cost where year in ('2013','2014') DataStage job structure; Dataset(input) -> lookup (referencing...
- Wed Apr 02, 2014 4:09 pm
- Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- Topic: Reference Oracle connector lookup in an ISD job (always on)
- Replies: 4
- Views: 6599
- Tue Apr 01, 2014 8:41 pm
- Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- Topic: Reference Oracle connector lookup in an ISD job (always on)
- Replies: 4
- Views: 6599
- Tue Apr 01, 2014 6:21 pm
- Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- Topic: Reference Oracle connector lookup in an ISD job (always on)
- Replies: 4
- Views: 6599
Reference Oracle connector lookup in an ISD job (always on)
My question is when an Oracle connector loads data into memory at the start of an ISD job, if it ever gets refereshed when the referenced table is updated and if yes what is the mechanism. Please let me know of any documents that may explain this. Example; ISD input --> lookup country/state ---> ISD...
- Tue Mar 18, 2014 11:39 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataStage Server job - need help with transformer
- Replies: 7
- Views: 5743
- Tue Mar 18, 2014 10:03 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataStage Server job - need help with transformer
- Replies: 7
- Views: 5743