DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 181 matches
Author Message
Resolved
 Topic: get file date as column value
deesh

Replies: 2
Views: 191

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 19, 2017 11:42 am   Subject: get file date as column value
Achieved by the file name column property in sequential file stage
 Topic: How to pass multiple files through looping activity
deesh

Replies: 2
Views: 69

PostForum: General   Posted: Wed Apr 19, 2017 11:40 am   Subject: How to pass multiple files through looping activity
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi, i am getting multiple files with the common structure, but my senior saying need to use the loop activity in sequence jobs and solve the issue.

Please let me know how to resolve by using start ...
Resolved
 Topic: get file date as column value
deesh

Replies: 2
Views: 191

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 10, 2017 9:49 pm   Subject: get file date as column value
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi,

I have a scenario like source file include date like ABCD10112016.dat . I need to derive that file date value '10112016' for one of the target field.

Could you help how to reach, Moreover wi ...
 Topic: Getting Host key verification failed while executing the DS
deesh

Replies: 2
Views: 177

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Mar 22, 2017 8:42 am   Subject: Getting Host key verification failed while executing the DS
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi
Getting Host key verification failed while executing the DS through unix
Please let me know in which scenario getting the issue, and whtat is the solvation.
main_program: APT configuration ...
Resolved
 Topic: String to decimal, unable to get proper data
deesh

Replies: 13
Views: 591

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Mar 22, 2017 6:24 am   Subject: String to decimal, unable to get proper data
I found the issue i am getting the control M char for that field and used below logic to remove the control and removing first three header rows in the file.

used External source stage

tail -n + ...
Resolved
 Topic: String to decimal, unable to get proper data
deesh

Replies: 13
Views: 591

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat Mar 18, 2017 10:25 am   Subject: String to decimal, unable to get proper data
Yes, seeing the results in peek stage.
Source data type string and target data type decimal(15,10)
Resolved
 Topic: String to decimal, unable to get proper data
deesh

Replies: 13
Views: 591

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Mar 17, 2017 8:36 pm   Subject: String to decimal, unable to get proper data
Please find below what are the option I tried.

Trim(column,' ','A')-- result '0.0'
String to decimal(trim(column))-- result '0.0'
Field(column'.','1') -- result ' 00100'
Field(column,'.','1'):'. ...
Resolved
 Topic: String to decimal, unable to get proper data
deesh

Replies: 13
Views: 591

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Mar 17, 2017 11:29 am   Subject: String to decimal, unable to get proper data
Yes converting the data ' 100.0' to '0.0' while doing string to decimal
Resolved
 Topic: String to decimal, unable to get proper data
deesh

Replies: 13
Views: 591

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Mar 17, 2017 7:55 am   Subject: Re: String to decimal, unable to get proper data
I have modify the statement, is above one is ok (no confused) --craig
Resolved
 Topic: String to decimal, unable to get proper data
deesh

Replies: 13
Views: 591

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Mar 17, 2017 6:59 am   Subject: String to decimal, unable to get proper data
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi,

We are doing data conversion from varchar to decimal, but instead of data ,we are getting value '000.0000'.

source data like ' 100.0000'(including space).

My experiments

I tried with t ...
Resolved
 Topic: Remove header while getting data through file stage
deesh

Replies: 3
Views: 271

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Mar 17, 2017 6:51 am   Subject: Remove header while getting data through file stage
Yes it's working fine with the previous message logic mentioned logic


If from a single file, then set value of "Source Program" to
Quote:
tail -n +4 <path>UKRIPR*.txt


thanks
Resolved
 Topic: Remove header while getting data through file stage
deesh

Replies: 3
Views: 271

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Mar 16, 2017 10:53 pm   Subject: Remove header while getting data through file stage
If i implemented that logic it's throwing the warnings like.

External_Source_14,0: Field "LAYER_LIM_AMT" has import error and no default value; data: {5 7 1 4 2 8 . 6 1 0d}, at offset: 209
Externa ...
Resolved
 Topic: Remove header while getting data through file stage
deesh

Replies: 3
Views: 271

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Mar 16, 2017 9:16 am   Subject: Remove header while getting data through file stage
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi,

I want to be remove my file header(first 3 rows), please let me know how to remove header.
My file name contains like UKRIPR*.txt, if i use with file pattern option i can't utilize the ' tail ...
 Topic: File_connector reading inssue
deesh

Replies: 1
Views: 296

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Nov 30, 2016 2:12 am   Subject: File_connector reading inssue
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi ,

While reading hadoop text file data from through File_connector stage getting below error.
If I read same file from local environment, getting success. please help me to resolve the issue.
...
 Topic: java.net.SocketException: Connection reset
deesh

Replies: 1
Views: 244

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Nov 30, 2016 2:06 am   Subject: java.net.SocketException: Connection reset
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi,

My job is failing while reading data through file_connector stage, please help me to resolve the issue.


Error: File_Connector_10,0: An exception occurred: com.ascential.e2.common.CC_Except ...
 

 Jump to:   



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