DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 383 matches
Author Message
Resolved
 Topic: Fatal Error: Added field has duplicate identifier(): X
chucksmith

Replies: 7
Views: 3080

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Sep 13, 2017 9:12 am   Subject: Fatal Error: Added field has duplicate identifier(): X
In my case, the primary input of the Lookup stage had two range key columns. One range call was RANGE(lkp.A, "<", lkp.B, ">", 0), and the other was RANGE(lkp.C, "<", lkp.B, ">", 0).

I ...
Resolved
 Topic: can not find metabag information for object
chucksmith

Replies: 7
Views: 2898

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Apr 27, 2017 9:43 am   Subject: can not find metabag information for object
And at 11.5, but the copy stage solution still works.
 Topic: Removal of Repeated Characters
chucksmith

Replies: 14
Views: 3169

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Nov 17, 2016 9:38 am   Subject: Removal of Repeated Characters
Back to the original question, please note that the convert() function deals with single byte comparison/conversion. The change() function deals with substrings.
 Topic: DS 9.1 Windows or Linux
chucksmith

Replies: 8
Views: 2289

PostForum: General   Posted: Wed Apr 16, 2014 12:43 pm   Subject: DS 9.1 Windows or Linux
I moved from 7.5.3 to 9.1, both on Windows. Now, I am running into issue using the new xml stage when creating large xml documents (e.g. feed to Amazon). Support tells me this stage runs on 32 bit j ...
Resolved
 Topic: Less than and greater than signs in xml data
chucksmith

Replies: 2
Views: 1153

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Fri Nov 11, 2011 3:29 pm   Subject: Less than and greater than signs in xml data
Page 4-5 of the XML PACK Designer Guide, set the Data Element value to XML.
 Topic: small square box
chucksmith

Replies: 3
Views: 845

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Nov 11, 2011 3:00 pm   Subject: small square box
This tool will create a dump of your file:

http://www.anotheritco.com/tools/download_dump_cobol_file_v3.htm
Resolved
 Topic: Less than and greater than signs in xml data
chucksmith

Replies: 2
Views: 1153

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Fri Nov 11, 2011 2:55 pm   Subject: Less than and greater than signs in xml data
DataStage® Release: 7x
Job Type: Server
OS: Windows
I am trying to pass xml tags as data via an XML Output stage. However, less than symbols are being converted to &lt; and greater than symbols are being converted to &gt;.

Is there any way ...
 Topic: Hashed file corruption
chucksmith

Replies: 5
Views: 3058

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Mar 24, 2011 5:33 pm   Subject: Hashed file corruption
FYI: if it is a 64-bit hashed file, you may have to use fixtool.


fixtool

The fixtool executable performs the file diagnostic and repair functions of

the File Tool option to UniVerse Admin l ...
 Topic: A new version of my List all files and tables tool...
chucksmith

Replies: 1
Views: 842

PostForum: General   Posted: Thu Jan 27, 2011 6:25 pm   Subject: A new version of my List all files and tables tool...
DataStage® Release: 7x
Job Type: Server
OS: Windows
Hi,

I just posted version 7px.b of my List all files and tables used by jobs in a dsx file.

This version does a much better job (1) connecting the link and stage properties, (2) extracting ...
Resolved
 Topic: DSPrepareJob ordering in a job control code
chucksmith

Replies: 5
Views: 2256

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 02, 2010 9:58 am   Subject: DSPrepareJob ordering in a job control code
My mistake. It returns a job handle.
Resolved
 Topic: DSPrepareJob ordering in a job control code
chucksmith

Replies: 5
Views: 2256

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 02, 2010 9:45 am   Subject: DSPrepareJob ordering in a job control code
Doesn't DSPrepareJob() return a status value? The code example is resetting the job handle which means the subsequent use of it will be invalid.
 Topic: Need to convert columns into rows in server 7.5
chucksmith

Replies: 4
Views: 1391

PostForum: General   Posted: Thu Dec 03, 2009 8:29 am   Subject: Need to convert columns into rows in server 7.5
If the number of potential output rows is variable, then you may have to take an I/O intensive approach. Convert the double quotes to nothing, and convert the semicolons to @VM (Convert(';"' ...
 Topic: RSS Feeds into RTI
chucksmith

Replies: 2
Views: 1377

PostForum: IBM® SOA Editions (Formerly RTI Services)   Posted: Tue Sep 22, 2009 4:54 pm   Subject: RSS Feeds into RTI
Using a transformer stage as input to an xml input stage, create an input column whose derivation is the URL of the RSS feed. In the xml input stage on the input tab, select the URL/File Path radio b ...
Resolved
 Topic: Row Counts and UserVariable activity
chucksmith

Replies: 7
Views: 1832

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jul 30, 2009 11:30 am   Subject: Row Counts and UserVariable activity
I have tools that allow you to store and retrieve values from a parameter table, and access them from within a sequence. They may help. Look at the DataStage Tools page on www.anotheritco.com .
 Topic: RSS Feeds into RTI
chucksmith

Replies: 2
Views: 1377

PostForum: IBM® SOA Editions (Formerly RTI Services)   Posted: Thu Jul 30, 2009 8:18 am   Subject: RSS Feeds into RTI
DataStage® Release: 8x
Job Type: Server
OS: Windows
Has anyone used SOA Edition (RTI) to capture a RSS feed?
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours