DSXchange

Hi I am using OracleEnt stage , user defined sql select max(RUN_ID) from schema.Table_Name Error executing View Data command:##E IIS-DSEE-TOPK-00007 06:43:51(012) <_PEEK_IDENT_> Input dataset does not have field: "RUN_ID". Target is sequential file (name of the stageMax_Run) datastage dire...

Hi I need to use a Data base table, Row_ID is the primary key, I need to get max value of ROW_ID and max value of ROW_ID value should available throughout (every where) the sequencer. Like a parameter value, max value of ROW_ID should available any where in the sequencer Can any one suggest me pleas...

Hi I am using Oracle Enterprisestage for Reading the data from a DB tables In the SQL statement I am using 'LIKE' . I need to pass the parmeter value to LIKE in the sql select statement . WHERE BA.col3 = SA.col3 AND MP.col2 LIKE 'SampleTable' I want to parameterise the SampleTable value Can you plea...

Hi OracleEntstage---->Transformerstage----->OracleEntstag I am using select query in OracleEnt stage.Selecting six columns. I am using Transformer stage. In Tx stage, adding a new column(int (10)) Run_ID on output link of Transformer. New column (in TX stage) is a primary key in the Target table. I ...

I am reding from txt file with SEQUENTIAL STAGE using schema file and i am loading into the data into Oracle table using Oracle Enterprise stage. Sequential file stage ----> Transformer ------> OracleEnterprise stage The writting order of the data in the target table is not same as order of the data...

I am developing a generic data loading process source -- Multiple txt files Target --- Multiple tables In my sequencer I am using User Variable Activity stages and Start loop and End loop stages,Job activity stages In sequencer first stage is uv stage((Name: Read_File)). which usess routine, to read...

Hi I need to add new column(Today_Day)(field type is Date) in transformer, I am using CurrentDate() fuction. This column (Today_Day) is not available in the source file. (Today_Day) type is Date I specified in the transformer In the target oracle table (Today_Day) filed type is Date. I am using Orac...

Your Sequential File stage used for writing does not have Null Field Value property in the Format or Columns tab, but your design includes at least one column marked as nullable. what should I specify for Null Field Value property in sequential file property page under Format Tab. Can you please ex...

You have apparently defined the record_delim and delim options to use the same value, as shown in the record schema you provided. Are the records truly delimited with a '^' character, or do they have a unix linefeed or dos/windows carriage return/linefeed delimiter instead? '^' charecter is there a...

Hi I am using sequential file stage with schema file but stage is not reading the data and giving warning messages below When validating export schema: At field "BQR": Exporting nullable field without null handling properties Field "BQR" delimiter would overrun input buffer, at o...

Actually I need to read the parmeter values from a table and pass them to datastge job(Multiple instance). If you have unix script to read params from table and passing the params ds job(multiple instance), can you let me konw the unix script. please let me know the implementation steps of unix and ...

Hi I need to pass the parameters for Datastage job (multiple instance) For each instance the following set of parameters I need to pass to DS job Source File Name, Schema File Name, Target Table Name, Invocation ID File1.txt, File1.schema, Table1, 1 File2.txt, File2.schema, Table2, 2 Like this I nee...

Hi I need to pass the parameters for Datastage job (multiple instance) For each instance the following set of parameters I need to pass to DS job SourceFileName, SchemaFileName, TargetTableName, Invocation ID File1.txt, File1.schema, Table1 , 1 File2.txt , File2.schema , Table2 , 2 Like this I need ...

Hi, I have 150 files (text) as source. I need to load 150 files data into 150 Oracle tables. Without any changes for columns order and data types. Every file has different number of columns. Delimiter is same (^) for all the files. I need to load 150 files data into 150 tables every day and simultan...

HI

In the Transfomer Input fileld is date

I want to subtract days (like 25) then populate to output field in the form of yyyy-mm-day.

Is it possible ? Then what is syntax

Srini