DSXchange

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...

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...

Not clear yet.

In example above, suppose the value of the input field going into the lookup is MY_VARIABLE='ABCXYZ'


How should the pl/sql look like? Please provide an example.

Did you ever figure this out?

Can one of you elaborate on IBM response below as it relates to this problem; Thanks ----------------------------------------------------------------------------- Thank you for contacting IBM Support. The "IN" Keyword is looking for a list of values to execute the query against. Unfortunat...

Thanks mike

It does work with the parameter set, it is strange though that it does not work with the host variable.




Anyone else has any idea on how to solve the original problem?

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 ...

I tested Mike's method as well with the same result.
here is how I constructed the string;

From Transformer Derivation;
"\'2013\',\'2014\'"

Here is the result from peak

Peek_1,0: in_year:'2013','2014' year:NULL month:NULL

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 ...

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...

It worked with the Sparse lookup.
Thank you all

I suppose the Sparse lookups pickup the latest the changes. Right?

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...

This option is only available Where a reference link originates from a UniVerse or ODBC stage. Does not work with my case (Oracle connector)

True, though in this situation will not work. The primary input will ultimately be from an ISD stage.