DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 57 matches
Author Message
 Topic: How to use FTP Stage to transfer into Mainframe
ScottDun

Replies: 1
Views: 356

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Oct 23, 2017 1:04 pm   Subject: How to use FTP Stage to transfer into Mainframe
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi again,

I am using an FTP to shoot a file into the mainframe. However, when I run into the mainframe I am running into a problem where I can only transfer 80 characters out of my 3600 characters. ...
Resolved
 Topic: Creating a Header
ScottDun

Replies: 3
Views: 397

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Oct 19, 2017 11:35 am   Subject: Creating a Header
Thanks for responding. So let me give you the entirety of the job. I am taking an FTP to an external filter to get rid of Header/Trailer. Then I am using
a transfomer to load two files and a DB2. Fo ...
Resolved
 Topic: Creating a Header
ScottDun

Replies: 3
Views: 397

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Oct 19, 2017 10:50 am   Subject: Creating a Header
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
Another brainbuster for you guys. I have a set of data that looks like this:

AD43829T||||4,5
AF87571S||||4,5
CP06459X||||4,5
AD99586W||||4,5
CK71846A||||4,5
In the transformer, I want to add ...
Resolved
 Topic: Remove the First and Last Record of File in FTP
ScottDun

Replies: 6
Views: 541

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Oct 19, 2017 10:39 am   Subject: Remove the First and Last Record of File in FTP
I used the FTP stage to upload a file then I used the external filter stage to use the sed '1d;$d'.

It worked.

Thanks all
Resolved
 Topic: Remove the First and Last Record of File in FTP
ScottDun

Replies: 6
Views: 541

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Oct 17, 2017 10:28 am   Subject: Remove the First and Last Record of File in FTP
Thanks for the reply. My FTP stage (incoming) I have the URI and the needed options to view data. I then bring it to a transformer and I can use @INROWNUM for the first row but the LastRow() function ...
Resolved
 Topic: Remove the First and Last Record of File in FTP
ScottDun

Replies: 6
Views: 541

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Oct 17, 2017 7:57 am   Subject: Remove the First and Last Record of File in FTP
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
I have a file with Header, Trailer as first and last records. I know about the sequential file sed "1d;\$d" aspect but I was wondering if there was a way to do this in the FTP stage.

Any help would ...
Workaround Reported
 Topic: How to validate a string of code
ScottDun

Replies: 11
Views: 15752

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Oct 05, 2017 8:24 am   Subject: How to validate a string of code
So for somebody with no DB2 knowledge, I could use ISNUMERIC for the 1st character. Is there a ISALPHA and an ISALPHANUM function as well. I am referring to your 'regular expression' comment from earl ...
Workaround Reported
 Topic: How to validate a string of code
ScottDun

Replies: 11
Views: 15752

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 04, 2017 12:46 pm   Subject: How to validate a string of code
FranklinE,

How would I use the Num function to get rid of the 0? For ex: Num(Link[3500,1]) will see if the 1st char is 0-9. Is there a manipulation that will be able to make sure that 0 is not incl ...
Workaround Reported
 Topic: How to validate a string of code
ScottDun

Replies: 11
Views: 15752

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Sep 27, 2017 10:41 am   Subject: How to validate a string of code
Im using this in the transformer using stage variables to create an error code. I figured it would be an If statement but I didnt know what the actual working of that would look like
Workaround Reported
 Topic: How to validate a string of code
ScottDun

Replies: 11
Views: 15752

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Sep 27, 2017 8:13 am   Subject: How to validate a string of code
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
Hi,

I am trying to validate a sting that comes in from a file. I am taking a set of characters and I need to make sure that they meet a certain criteria. The character string will be in a fixed pos ...
Workaround Reported
 Topic: Using @Iteration Loop Condition
ScottDun

Replies: 2
Views: 453

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Apr 06, 2017 6:39 am   Subject: Using @Iteration Loop Condition
B and C need only to be populated if they have a value of 159 and 158, respectively. If B doesn't have 159, then it will not be included; same goes for C.
Workaround Reported
 Topic: Using @Iteration Loop Condition
ScottDun

Replies: 2
Views: 453

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Apr 04, 2017 1:27 pm   Subject: Using @Iteration Loop Condition
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
Hi,

I am creating a job in which I need to use an iteration. The job I have has a seq. file with one row of data, two transformers and im mapping to a table using db2 connector. In the first transf ...
Resolved
 Topic: DB2 Connector Update Issue
ScottDun

Replies: 4
Views: 582

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Feb 06, 2017 2:02 pm   Subject: DB2 Connector Update Issue
I mentioned this to see if it would have any effect on the performance. We will be running tonight to see if it persists. Thanks for your help.
Resolved
 Topic: DB2 Connector Update Issue
ScottDun

Replies: 4
Views: 582

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Feb 06, 2017 1:43 pm   Subject: DB2 Connector Update Issue
The SQLCODE is 40506, Native Error Code is -1,476, Error code -911. Our architect wants us at 2000 array count
Resolved
 Topic: DB2 Connector Update Issue
ScottDun

Replies: 4
Views: 582

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Feb 06, 2017 1:13 pm   Subject: DB2 Connector Update Issue
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
Hi All,

I am having an issue with a parallel job within a sequence that will fail after the first run and then, when restarted, it works fine. I am getting the fatal error "DB2_Connector_18,0: An i ...
 

 Jump to:   



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