try use
select Computer, SoftwareProduct, DataStore, DataSchema from MetaStage_Loc_Info with UR
Search found 56 matches
- Fri Oct 14, 2011 2:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC Connection issue
- Replies: 3
- Views: 6908
- Mon Oct 10, 2011 9:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 IN clause
- Replies: 10
- Views: 7798
- Sun Oct 02, 2011 10:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Teradata Connector load using Bulk mode
- Replies: 7
- Views: 7662
- Sun Sep 18, 2011 1:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Regarding Connecting to iseries data from Datastage
- Replies: 3
- Views: 6035
- Wed Jul 06, 2011 11:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to make Oracle connector read source data in parallel
- Replies: 3
- Views: 5922
if you want to read 10000 rows, and you are reading by 2 nodes, you should put rownum <= 5000 in your sql. you are absolutely in the right direction. you are spliting the rows while enabling partition read. to read the database in parallel increase the performance much. if you are loading the data r...
- Tue Jul 05, 2011 9:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to make Oracle connector read source data in parallel
- Replies: 3
- Views: 5922
- Mon May 09, 2011 7:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: switch stage
- Replies: 8
- Views: 13345
- Tue Apr 26, 2011 7:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Connector Stage Issue
- Replies: 3
- Views: 5094
- Sun Apr 17, 2011 8:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Accessing DB2 (iSeries) at AS400 from DataStage server 8.1
- Replies: 7
- Views: 12566
- Thu Apr 14, 2011 3:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to view data in Teradata Enterprise stage
- Replies: 5
- Views: 6661
Hi,
If you use user defined sql in the stage, you should add an alias name behind each column in the select list, and the alias name should be mapped to the column name defined in the table metadata.
so the sql should look like this
If you use user defined sql in the stage, you should add an alias name behind each column in the select list, and the alias name should be mapped to the column name defined in the table metadata.
so the sql should look like this
Code: Select all
select
c1 Accnt_Num,
c2 Crdt_Mngmt_Type_Id,
.....
from t1
- Fri Apr 08, 2011 9:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: rsh issued, no response received
- Replies: 3
- Views: 7464
- Tue Apr 05, 2011 2:55 am
- Forum: General
- Topic: Datastage on UNIX vs DataStage on Windows
- Replies: 3
- Views: 5528
- Tue Apr 05, 2011 2:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with connecting to Oracle via ODBC Connector stage
- Replies: 2
- Views: 7781
- Sat Apr 02, 2011 11:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to process chinese characters as it is
- Replies: 2
- Views: 3437
- Sun Mar 13, 2011 9:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Configuration file error in Datastage
- Replies: 12
- Views: 15346