Finally, I was able to get it done with directions from the below link! Thank you everyone for your help and guidance.
https://www.youtube.com/watch?v=PLJGVSPtBHA
Search found 34 matches
- Thu Sep 11, 2014 10:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need help with reading XML file
- Replies: 16
- Views: 8460
- Mon Sep 08, 2014 5:25 pm
- Forum: General
- Topic: Problem with using SQL statement as parameter
- Replies: 2
- Views: 1271
- Mon Sep 08, 2014 3:35 pm
- Forum: General
- Topic: Problem with using SQL statement as parameter
- Replies: 2
- Views: 1271
Problem with using SQL statement as parameter
Hi all, I'm trying to parametrize part of an SQL statement from a query in a SQL Server stage. CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 120) + ' 5:00') - 1 The error I'm getting is saying that ' 5:00' is an invalid argument. I've tried double quotes and using single quotes around the entire...
- Wed Sep 03, 2014 5:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Chinese characters on Netezza
- Replies: 0
- Views: 1319
Chinese characters on Netezza
~ Not sure why there is no option for 9x or 11x on the DataStage release dropdown while creating a new thread! We recently purchased IBM Infosphere 9x and Netezza 7 to migrate our old systems from SSIS and SQL Server 2005 respectively. Its a brand new installation. While trying to read data from SQL...