DSXchange

My Job is RCP Enabled. I don't have a defined metadata before Column export stage. !!!

Hi I am capturing database rejections by adding reject link to oracle connector stage. At the other end am restructuring the same rejects as tab separated values through Column Export stage and writing them into a single column. My Job is RCP enabled. Since few columns have Decimal datatype in the O...

This functionality is working fine in Oracle connector stage but I don't know what's wrong with oracle enterprise stage.

Hi, I am trying to Restructure data from a File through Column Import Stage.In Column Import Stage, have assinged Schema File with RCP enabled. Since I am expecting Special characters in the File, so I set 'Ustring' in Schema file. Say, when I mentioned ustring max[5] in schema file and if get data ...

IHi all, I am trying to capture rejects from oracle enterprise stage while failure in inserting or updating the data into database table. Have tried with example data where actual data length exceeds the data length mentined in Database table. My job is getting aborted with the following error. But ...

Got it fixed. One of my friends figured it out. Am using 8.1 & am directly reading Parameterset value files and assinging parameters respectively to the job. Never came to mind about assigning parameterset with parameter value. So when we assigned parameterset name to the value, it worked out. Y...

Value file format is: Value1=/local/abc Value2=/local/apps/Datastage/projects/ParameterSets/ps_abc Value3=/local/apps/Datastage/projects/reusable Value4=1.schema Value5=INSERT INTO TB_OBJECTS (DEVIATION_ID, SAMPLE_ID, TEST_ID, TEST_VERSION, TEST_VARIANT, TEST_INSTANCE, IMPLICATION_DATE, DEIMPLICATIO...

No, Have checked everything. File is not empty & Yes I have multiple '=' for 1 parameter but atleast excluding that it should return values for other parameters.

when get DSLogInfo for the File, it showing perfect list of parameters. Don't no something going funny.

No, have checked this. It's not taking from previous run DSAttach(). DSSetParam() always assigning Null values. Some link is missing somewhere. I am not able to figure this. ************************************************ PathName = ValueFileDir:'/':ValueFile Cmd2="cat ":PathName Call DSE...

Am trying to execute the job through Job Control. Job is getting executed but with parameters as Null values. when I assign parameters it's assigning Null values to the job. Can anybody figure where am going wrong. PathName = ValueFileDir:'/':ValueFile Cmd2="cat ":PathName Call DSExecute(&...

My Bad, How could I missed this? tracing mode was enabled. !!!

CSV files are Tab delimited. we are using Sequential file stage to read the records which is reading all the Records but column Import stage where schema file is assinged is propogating only 100 records out of it. record {final_delim=end, delim='\t', null_field='', quote=none, padchar=' ',print_fiel...

Hello , We are implementing Schema file approach for processing nearly 50 CSV Files with using 50 different schema files. If data volume in a CSV file is 1 million records, but schema file is propogating only 100 Records. we tried with multiple scenarions where If: 1. More than 100 records in CSV fi...

No,am talking about Text qualifier. So used the property "quote".

After long time,I gave an another try on this. Found some new behavior which might be new to me but not for others. Well that is: Quotes can be of 2 characters (say: "$~") but Datastage is treats "$" as opening character & simultameously "~" as closing character. Pl...