Search found 296 matches
- Fri Apr 29, 2011 8:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue wit data extraction
- Replies: 2
- Views: 3295
I believe this is a limitation of Teradata's FastExport. From the DS documentation on the teraread Operator. v Single-AMP requests are not allowed. These are SELECTs satisfied by an equality term on the primary index or on a unique secondary index. Meaning use the Teradata API instead. Disclaimer: T...
- Thu Apr 28, 2011 5:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Current date in Teredata
- Replies: 9
- Views: 6598
- Wed Apr 27, 2011 2:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Current date in Teredata
- Replies: 9
- Views: 6598
- Thu Apr 14, 2011 11:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Teradata API Stage
- Replies: 4
- Views: 3469
- Tue Sep 28, 2010 7:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: change xpath expressions of xml Dymanically
- Replies: 7
- Views: 5201
I'm happy that worked for you. The application I used it for was multiple xml schemas going to an Oracle db. The schemas described different hedged options like commodities (rice, hops, barley, the essentials for beer), as well as hedging international currency fluctuations, transportation costs, st...
- Thu Sep 23, 2010 2:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: change xpath expressions of xml Dymanically
- Replies: 7
- Views: 5201
I don't have access to DataStage so this is from memory and might be a little vague. It has been over a year since I talked DataStage so my accent might be rather thick. You can change it dynamically (per job run that is) using parameters. Parameters will work within the description field. Parameter...
- Wed Jul 15, 2009 10:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential File Stage in Parallel and Server
- Replies: 10
- Views: 7140
- Mon Jul 13, 2009 5:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Which DB used for ORCH_WORK table
- Replies: 5
- Views: 5020
Yes it is. Use WORKDB=<Database> as an Additional Connection Options. It is a property available within the Properties tab of the Teradata Enterprise Stage within the DB Options Mode property. Here's what we use. I know of no other options available but would love to learn of more if anyone knows of...
- Wed Jul 01, 2009 11:16 am
- Forum: General
- Topic: Adding current Date with the file
- Replies: 23
- Views: 8206
- Tue Jun 16, 2009 7:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Mergestage issue
- Replies: 5
- Views: 2953
You are using two nodes. This means you are partitioning on two nodes. This means, in general, half the data goes to one partition and half the data goes to the other partition. If you have not consciously planned for this partitioning then Datastage has done it for you. Erroneously, it would seem. ...
- Tue Jun 09, 2009 6:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Controlling Sessions w/Teradata Enterprise Stage (TES)
- Replies: 3
- Views: 2576
- Mon Jun 08, 2009 6:07 am
- Forum: General
- Topic: datastage xml parsing
- Replies: 5
- Views: 6643
You canot parse the Language tag? Then your Xpath to the Language element has a typo or other fundamental problem. If you are getting a single language when you expect a row per Language then your Repeating element is probably mis-defined. Is the Repeating Element set to the Language element so that...
- Fri Jun 05, 2009 6:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parameters
- Replies: 7
- Views: 4476
- Tue Jun 02, 2009 10:45 am
- Forum: General
- Topic: Useful Perl Scripts I have written
- Replies: 24
- Views: 37079
- Wed May 27, 2009 6:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: APT_TeraSync: could not create operator sync table
- Replies: 1
- Views: 1877