DSXchange

Hi, I am using the DB2 Stage as source to connect to DB2 tables. I am hitting two errors. First when I try to import the tables and second time when I try viewing the data . I try importing the tables through "Import Plug-in Meta Data" I get this error: Unable to obtain list of available t...

The commit interval is 200 and the parameter array size is 1. If I increase the parameter array size....I start getting the error at runtime. I am Sorry to post this again. I am trying to figure this out for quite sometime through DataStage as my group is already using this tool for the DB2 load. Wh...

Hello, I am trying to directly load one teradata table from a flat file. There is no changes in data...I am just directly loading the flat file data into a one table with one transformer in between. I am using the ODBC to connect to the database. But my loading session is very slow. In the monitor i...

Thanks for the quick response. Actually, I have never worked on the MLoad utility. Since the company I am working for has been using DataStage for sometime, so I am using the this ETL tool for this loading. Is DataStage is not very effective with Teradata? I will be greatful if you can suggest anyth...

Hi, I have a simple mapping on datastage. I am loading data from a flat file (with 19 columns with about 500,000 rows)into single Teradata table through a transformer. I don't have any native stage driver for Teradata, hence using the ODBC stage to connect to teradata database. But it is taking more...

Hi, Thanks for the responding to my question: I tried your suggestion. But I got all the 100,000 rows with the value of 0 and 1. 1 is returned for the 4 digit number and 0 for all other digits. I just need to extract only those rows that has only 4 digit number in a column. But currently it extracts...

Hi,

I have to extract ONLY the four digit number in a column. I have a char(5) column (in a flat file) that has numbers from 1 digits to 5 digits. I have to extract only those rows from this file that contains 4 digits number and load into the target.

Thanks for you help

Hi,

I am new to DataStage. I am looking for an available function to change the date format from YYYY-MM-DD to YY-MM-DD. Actually my source flat file has the YYYY-MM-DD format but my target teradata table has a column that has Date datatype and is defined to take YY-MM-DD date format.

Thanks

Hi, Is there a way to start the UniqueId from 1268265 rather than from one using KeyMgtGetNextValue. Thanks You can use KeyMgtGetNextValue or KeyMgtGetNextValueConcurrent depending on whether you have mutiple processes using the same sequence key, and then if you need to re-set the keys, you can use...

Hi,

How do we generate the Unique ID like (1,2,3....) for every row inserted in RDBMS using DataStage.

Thanks

Hi Ogmios, Thanks for the quick response. We are using ODBC to connect to the TeraData Database as teradata stage is not available to us. I am not sure if I should ask this question in this or put this as a new topic: How do we generate the Unique Sequence ID like (1,2,3....) for every row in DataSt...

Hi, I am new to DataStage. I have a situation related to one of the jobs I am creating on DataStage. I have a BatchId column in one of my RDBMS tables. I have to populate it with Unique ID that is same per job run. If I run the Job today and insert 10 rows, the BatchID column needs to be same(say: 1...

Hi, I have a new job and new to datastage. My company is currently in a process of migrating from Indigo(ETL) to DataStage7.1. We have few flat files residing on the third party secured website. The website does not currently support FTP. Currently, Indigo is able to make the https:\\ connection to ...