Search found 61 matches
- Sun May 19, 2019 9:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sending an Excel Sheet to Amazon S3
- Replies: 5
- Views: 4560
I saw that, however, I didn't see where it says importing with multiple tabs. The documentation that I saw doesn't show, as well. The filepath is Link_Excel_EXTR, I go to the Link dropdown and it only shows that link, not multiple links [the documentation says Department and Employees somehow]. When...
- Sun May 19, 2019 6:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sending an Excel Sheet to Amazon S3
- Replies: 5
- Views: 4560
Re: Sending an Excel Sheet to Amazon S3
Requirements from customer are to have the two tabs in same excel sheet. I tried a job doing a funnel but it won't work on the exporting columns
- Fri May 17, 2019 1:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sending an Excel Sheet to Amazon S3
- Replies: 5
- Views: 4560
Sending an Excel Sheet to Amazon S3
Hi, I have an excel sheet (2 tabs, different column names) that I want to simply push to an Amazon S3 bucket. Basically, unstructured data stage --> Amazon S3 My problem, potentially overseeing what I need, is that I want both tabs to be output and I cannot figure how to bring them in. Quickly on Ex...
- Mon Apr 22, 2019 1:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Trying to extract row with certain criteria
- Replies: 2
- Views: 3221
Trying to extract row with certain criteria
Hi, I am bringing in 4 sequential files and performing a funnel. An example is shown below of one person with three rows: ID NAME Stat Code Stat Code Description 17137 TOM 05 RECEIVED 17138 TOM 04 ADD'L 17139 TOM 08 PENDING The files (combined) are 125 rows. I bring this into the transformer stage, ...
- Mon Oct 23, 2017 1:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to use FTP Stage to transfer into Mainframe
- Replies: 1
- Views: 1963
How to use FTP Stage to transfer into Mainframe
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. I use my username/password for connection, FTP transfer mode and transfer ASCII with Overwrite as yes....
- Thu Oct 19, 2017 11:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Creating a Header
- Replies: 3
- Views: 3524
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. For the file in question, I have a constraint based on my stage variables (I am creating error codes for...
- Thu Oct 19, 2017 10:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Creating a Header
- Replies: 3
- Views: 3524
Creating a Header
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 a header to this to make the output look like this: File partially processed|Total-10|Accepted-0|Rejected-10|...
- Thu Oct 19, 2017 10:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Remove the First and Last Record of File in FTP
- Replies: 6
- Views: 4260
- Tue Oct 17, 2017 10:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Remove the First and Last Record of File in FTP
- Replies: 6
- Views: 4260
- Tue Oct 17, 2017 7:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Remove the First and Last Record of File in FTP
- Replies: 6
- Views: 4260
Remove the First and Last Record of File in FTP
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 be great.
Thanks,
Scott
Any help would be great.
Thanks,
Scott
- Thu Oct 05, 2017 8:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to validate a string of code
- Replies: 11
- Views: 23157
- Wed Oct 04, 2017 12:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to validate a string of code
- Replies: 11
- Views: 23157
- Wed Sep 27, 2017 10:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to validate a string of code
- Replies: 11
- Views: 23157
- Wed Sep 27, 2017 8:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to validate a string of code
- Replies: 11
- Views: 23157
How to validate a string of code
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 position in a file, 3500-3510 to be exact. First off, I need to make sure that there are no spaces and zer...
- Thu Apr 06, 2017 6:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Using @Iteration Loop Condition
- Replies: 2
- Views: 2406