DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 183 matches
Author Message
 Topic: Reading multiple xlsx files
deesh

Replies: 3
Views: 179

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 09, 2017 5:51 am   Subject: Reading multiple xlsx files
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi,

My requirement also same like [url=http://www.dsxchange.com/viewtopic.php?t=156727]this requirement, getting multiple .xlsx files.
Can i know how the template looks?

My requirement :

1. ...
 Topic: How to load encrypted data into netezza
deesh

Replies: 1
Views: 250

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun May 07, 2017 9:06 am   Subject: How to load encrypted data into netezza
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi,

We are trying to load the encrypted data into netezza, but getting error due to bad rows.

Can some one tell me how to load encrypted data into netezza.

First we are loading data from ora ...
Resolved
 Topic: get file date as column value
deesh

Replies: 2
Views: 416

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: 233

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: 416

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: 260

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: 824

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: 824

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: 824

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: 824

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: 824

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: 824

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: 401

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: 401

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: 401

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 ...
 

 Jump to:   



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