Search found 195 matches
- Fri Sep 27, 2019 4:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to handle the Nulls
- Replies: 3
- Views: 4771
Hi, The defualt value coming from netezza, but unidentified what it is and some times will come blank(null) and some times come withe data like '1/100 ??'. but i need data cleanse in datastage, i used pad string and convert functions. But unable to remove that kind of data and yellowbricks not accep...
- Sat Sep 21, 2019 11:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to handle the Nulls
- Replies: 3
- Views: 4771
Unable to handle the Nulls
Hi We are loading the data from netezza to yellowbricks but getting below error. ODBC_Connector_15,0: ODBC function "SQLExecute" reported: SQLSTATE = HY000: Native Error Code = 3452617: Msg = [IBM(DataDirect OEM)][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]ERROR: invalid byte sequenc...
- Sat Sep 21, 2019 11:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: can we use "IF exists " statement and create state
- Replies: 2
- Views: 3571
- Wed Sep 11, 2019 6:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: can we use "IF exists " statement and create state
- Replies: 2
- Views: 3571
can we use "IF exists " statement and create state
Hi, I am trying to run below query in odbc_connector(before sql statement), facing issue. Loading data from netezza to yellowbrick. and same time create statement table in before sql and insert table is same, failing job in this scenario also if both names are same, working fine in netezza connector...
- Mon Jul 15, 2019 5:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage - connector for Yellow bricks Database
- Replies: 2
- Views: 4064
Datastage - connector for Yellow bricks Database
Hi,
Please provide me the information , if any one using or having an idea how to connect yellow bricks database in datastage tool
Please provide me the information , if any one using or having an idea how to connect yellow bricks database in datastage tool
- Mon Aug 13, 2018 4:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Junk characters when moving data from VARCHAR to CHAR
- Replies: 4
- Views: 3506
- Mon Aug 13, 2018 5:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Junk characters when moving data from VARCHAR to CHAR
- Replies: 4
- Views: 3506
Junk characters when moving data from VARCHAR to CHAR
Hi, My source having CHAR datatype and target has VARCHAR datatype. While moving data I am getting junk character into target. Same thing s happening while moving data from VARCHAR to CHAR. One of the options is to trim the column through out the job, but I need a better option. Please suggest how t...
- Wed May 23, 2018 1:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: First record populating while using XML stage
- Replies: 1
- Views: 2107
First record populating while using XML stage
Hi, I am trying to extract the data from xml file, i tried with the one of the online file (books xml file) with the XML stage, retrieving only the first row and remaining rows are not populating and not showing any warning or error, Same file tried with the XML Input stage, it was working fine and ...
- Wed May 02, 2018 5:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: RCP error with schema files and updates
- Replies: 2
- Views: 2364
RCP error with schema files and updates
Hi, I too facing same issue as noted here. Using RCP in my job without defining the columns in job , executing the job with schema files, if i use only Insert job working fine. If i use update then insert with the key's(columns in file) throwing same above error, could some one suggest how to resolv...
- Tue Mar 27, 2018 3:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Records are not populating while Using RCP in job
- Replies: 2
- Views: 2765
Records are not populating while Using RCP in job
Hi, We are trying to pull the data with different metadata, for that taken below steps. 1. Sequencial file --> providing file, schema_file and enable RCP 2. Transformer -- > enabled RCP and no columns are mapped 3. Sequencial file---> Target We are getting the count in perfomance statistics, but not...
- Thu Feb 01, 2018 9:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML file, one xsd call internally one more xsd
- Replies: 2
- Views: 2496
XML file, one xsd call internally one more xsd
Hi,
I have XML file, which contains two xsd's columns, no idea how to work with two xsd's .
one xsd calling internally one more xsd.
I have XML file, which contains two xsd's columns, no idea how to work with two xsd's .
one xsd calling internally one more xsd.
- Tue Jan 30, 2018 7:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Getting more records while using lookup
- Replies: 3
- Views: 2632
- Tue Jan 30, 2018 9:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Getting more records while using lookup
- Replies: 3
- Views: 2632
Getting more records while using lookup
Hi,
I am using lookup, from main Stream getting 3582, and from reference getting 112 records , but lookup output 16201 records.
Using continue( left join), if we mention continue output should match 3582.
Please help me out, if some one faced this kind of issue
I am using lookup, from main Stream getting 3582, and from reference getting 112 records , but lookup output 16201 records.
Using continue( left join), if we mention continue output should match 3582.
Please help me out, if some one faced this kind of issue
- Wed Nov 01, 2017 1:09 pm
- Forum: General
- Topic: execute ds job through command line with env file
- Replies: 5
- Views: 3487
execute ds job through command line with env file
Hi, I am trying to execute the ds job through command line. when i am trying include the parameter set in the command line job is triggering, but if i include env variables in the command line job is failing. 1.Please let me know how to run command line with env variables. 2. Please let me know how ...
- Fri Jun 09, 2017 5:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading multiple xlsx files
- Replies: 3
- Views: 2997
Reading multiple xlsx files
Hi, My requirement also same like this requirement, getting multiple .xlsx files. Can i know how the template looks? My requirement : 1. Getting multiple files and read it into text file 2. In target we have max 100 columns, but each file has different column counts, Example: file1 contains 10 colum...