Search found 53125 matches
- Tue Jan 30, 2007 3:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Renaming and deleting a dataset
- Replies: 34
- Views: 12192
- Tue Jan 30, 2007 3:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: List of DS Engine Commands
- Replies: 5
- Views: 2003
- Tue Jan 30, 2007 3:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to convert Read only share container into R/W mode
- Replies: 11
- Views: 2136
Code: Select all
UPDATE DS_CONTAINERS SET READONLY = 'NRO' WHERE NAME = '<<Container Name>>';It may be the case that READONLY was not set to 'RO'. There are other values set by other utilities that also indicate a read-only status.
- Tue Jan 30, 2007 2:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Getting category list in a project
- Replies: 5
- Views: 1488
- Tue Jan 30, 2007 2:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal Truncation -RESOLVED
- Replies: 8
- Views: 2122
- Tue Jan 30, 2007 2:42 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Checking whether string is numerical or not
- Replies: 3
- Views: 736
Assuming that the value is always 20 characters long:
Code: Select all
If InLink.MyColumn Matches "1A19N" Then InLink.MyColumn[2,4] Else ""- Tue Jan 30, 2007 2:38 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Initialize Transformer stage variables
- Replies: 6
- Views: 1392
Code: Select all
SELECT col2 || ':' || col6 || ':' || col7 FROM TABLE WHERE ...- Tue Jan 30, 2007 2:35 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How can i inport a dll in datastage designer
- Replies: 10
- Views: 3728
In Manager, choose Import > External Function Definitions (see Manager Guide , page 8-17) This places an entry in the Routines branch of the Repository describing the external (ActiveX) function, how many arguments it has, and the DLL in which it resides and the automation class within that DLL. Not...
- Tue Jan 30, 2007 2:26 pm
- Forum: IBM QualityStage
- Topic: cannot see output in quality stage
- Replies: 9
- Views: 4503
- Tue Jan 30, 2007 5:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data Quality via DSRoutine
- Replies: 5
- Views: 2184
Can you try describing your "empty" strings in code as '\0' ? You could also implement the logic in a parallel Transformer job, compile the job, then inspect the generated C++ code for ideas about coding your function. (You'll also find, if you're on 7.5.1A or later, that the Transformer stage is qu...
- Tue Jan 30, 2007 5:51 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Routine to connect to DB2
- Replies: 14
- Views: 6824
Your original post on this thread suggested that your DataStage server is on Windows, which is why I suggested "DOS" as the first argument of the DSExecute() call. That "UNIX" works tells me that your DataStage server is, in fact, on a UNIX machine. Had your DataStage server actually been on a Windo...
- Tue Jan 30, 2007 5:47 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage, Oracle and UTF-8
- Replies: 3
- Views: 2470
UTF-8 is not a single standard. To say that UTF-8 is a standard is like saying that UNIX is a standard. There are many eight bit Unicode Transformation Format schemes. Even the one used inside DataStage is idiosyncratic, as it preserves dynamic array delimiter markers as single-byte characters. It's...
- Tue Jan 30, 2007 5:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: datastage date in sql query
- Replies: 10
- Views: 5415
- Tue Jan 30, 2007 5:40 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Reference link get the first row of the reference table
- Replies: 29
- Views: 4178
- Mon Jan 29, 2007 11:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Jobs Failing
- Replies: 6
- Views: 1399