DSXchange

with RCP we are reading almost 500 tables and creating files. our target teams identified some of the key column displaying in decimal. they don't want in decimal.....

hi Chulette,

I have tried importing metadat, datatype changed to Decimal but we need integer

Thanks

hi,

we have datatype number in oracle database, but when we try to import the data in datastage it is converting decimal datatype. is it possible to convert as int instead of decmail with out manua intervention.because we are using runtime column propagation for around 100 Tables in same job.

Hi All,

I have to read and write data in same table with timeId change we have to append same records in table. could you please let me know it is possible in same job without having locks and other issues. i am using sql server database.

Thanks
Mallikharjuna Reddy

Please let me know if anybody know how to read the sharepoint excel file in datastage.

Thanks

hi,

I have requirement to read files from share point. is it possible to read files from share point? if yes please let me know the steps.

Thanks

Hi, i will receive monthly files , file names are not static. yyyymmdd change based on date of extract. and control file contains record count of source file, i am reading source file and aggregating for record count and checking with control file record count. if both counts are not matching then a...

hi,

I am not getting any error, job just hanging and not reading the files.

i have given pattern for both data file and control file pattern like control file SRS_????????_Control.csv .but it is not working . if i use '*" both files are reading in same source. I have give SRS_*.csv then both files are reading in same source.

hi, Our datastage server is on windows. we are receiving 2 files, data file SRS_YYYYMMDD.csv(YYYYMMDD is year month and date) and control file SRS_YYYYMMDD_Control.csv. I have to read both files in same job and check count match. the problem hear is wild character(?) is not working when i tried to r...

Hi, I am reading '|~|' delimited .csv file data. job is working fine and able to read all the records but i am getting the below warning message "Field "Site_ID" has import error and no default value; data: {S i t e - I D}, at offset: 24:" please let me know if any changes requir...

Hi,

in my source file i have some field values are in Chinese characters. I am not able to read from sequential stage. Please let me know how i can read these characters.

Thanks in Advance

Hi, We have to load the data in SAP by using BW load stage. my job is aborting with error message with error message "Failure during execution of operator logic." but i am just mapping only one field that is vhar datatype to same datatype. any environmental variable which gives the detail ...

Hi,

We are receiving |~| delimited file. We are not able to use "|~|" delimiter in the sequential file stage. The sequential file stage is only allowing either | or ~ not allowing "|~|". Please let us know how to use this delimiter in DataStage.

Thanks
Mallikharjuna Reddy

Hi All, I am facing Issue in reading null values for float data types in sequential file. my requirement is not to change data type and not to use any default value. if we change datatype as varchar then it is possible to convert to float data type and load null values in sap BW system? Thanks in ad...