DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 1220 matches
Author Message
Workaround Reported
 Topic: How to read the space delimited file??
SURA

Replies: 9
Views: 256

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Apr 18, 2017 9:15 pm   Subject: How to read the space delimited file??
Yes , i am marking this thread as Workaround.

Thanks to all for your time and help.
Workaround Reported
 Topic: How to read the space delimited file??
SURA

Replies: 9
Views: 256

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Apr 18, 2017 5:57 pm   Subject: How to read the space delimited file??
The ideal "solution" is to push this back on whoever is responsible for .

You are 100% right.

The issue are...

1. When they gave the sample file, it wasn't that bad. Though the work is messy ...
Workaround Reported
 Topic: How to read the space delimited file??
SURA

Replies: 9
Views: 256

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Apr 18, 2017 5:48 pm   Subject: Re: How to read the space delimited file??
I am thinking to use to string match and then find a way to load the data by using field function.
Or that string match followed by a substring. Once you find the position of an ...

Yes that exact ...
Workaround Reported
 Topic: How to read the space delimited file??
SURA

Replies: 9
Views: 256

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Apr 18, 2017 5:47 pm   Subject: How to read the space delimited file??
Have you tried using a Sequential File stage with space (or 0x20) specified as the field delimiter character? If so, what was the result? ...

Ray

Yes i tried that option . The issue I have her ...
Workaround Reported
 Topic: How to read the space delimited file??
SURA

Replies: 9
Views: 256

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 17, 2017 11:34 pm   Subject: How to read the space delimited file??
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Hi there


I need some suggestions to read this file using datastage. This is a log file data which need to be loaded into a table.

These all are the columns i am after:

DATE
TIME
Event
U ...
Resolved
 Topic: UTC to AEST
SURA

Replies: 9
Views: 685

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Feb 01, 2017 8:21 pm   Subject: UTC to AEST
Thanks Ray for cautioning.

In this office somehow a manual process has been implemented as someone who physically update the reference table to get the offset. This table will always (I wish alwa ...
Resolved
 Topic: UTC to AEST
SURA

Replies: 9
Views: 685

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jan 30, 2017 4:21 pm   Subject: UTC to AEST
It worked perfectly.

Thanks to all for your help.
Resolved
 Topic: UTC to AEST
SURA

Replies: 9
Views: 685

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jan 30, 2017 3:46 pm   Subject: UTC to AEST
Hi Chulett

DateOffsetByComponents(%basedate%,%yearoffset%,%monthoffset%,%dayoffset%)

This function doesn’t have time option, in such case how do i add 11 hours offset?

Am i missing so ...
Resolved
 Topic: UTC to AEST
SURA

Replies: 9
Views: 685

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jan 30, 2017 3:40 pm   Subject: UTC to AEST
Thanks chulett.

Yes it is.

I will check this.
Resolved
 Topic: UTC to AEST
SURA

Replies: 9
Views: 685

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jan 30, 2017 3:39 pm   Subject: UTC to AEST
Thanks Ray
Resolved
 Topic: UTC to AEST
SURA

Replies: 9
Views: 685

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Jan 29, 2017 10:47 pm   Subject: UTC to AEST
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Hello All

Source : File
Target : Table
UTC Time: Timestamp (yyyy-mm-dd hh:mm:ss)

I have a reference table where i can get the offset numbers such as 11 or 10 based on the range lookup with the ...
 Topic: Modifying the variables names in sequencers and jobs
SURA

Replies: 2
Views: 460

PostForum: General   Posted: Sun Oct 23, 2016 8:51 pm   Subject: Modifying the variables names in sequencers and jobs
You can export the project, replace the string and import it back.

Take the project back up. it might create issue if you did mistake.

Notes: Import it in a new project and see how it looks like ...
 Topic: Sequential file stage error
SURA

Replies: 4
Views: 650

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Oct 07, 2016 11:56 pm   Subject: Re: Sequential file stage error
Filename: `ls -name Historical Volumes*.csv #FilePath#`
Method: File pattern

Is it the same issue you have raised before?

By looking your command i doubt it may not work.
 Topic: Reading multiple files from network using Sequential stage
SURA

Replies: 21
Views: 1656

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 05, 2016 5:35 pm   Subject: Reading multiple files from network using Sequential stage
Is there any errors or warnings when you ran the job?

Sorry to ask, Have you changed the method to file pattern?
 Topic: Reading multiple files from network using Sequential stage
SURA

Replies: 21
Views: 1656

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 05, 2016 5:11 pm   Subject: Reading multiple files from network using Sequential stage
Now you have the space in the file names Sad

can you able to create few test files without space and place it the same server and try to read it!

This will eliminate the file path issue. Next c ...
 

 Jump to:   



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