DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 35 matches
Author Message
 Topic: Spambot
sriven786

Replies: 29
Views: 4893

PostForum: Site/Forum   Posted: Fri Dec 22, 2017 10:07 am   Subject: Spambot
lzm004- I guess this is the User, Please check the Posts and delete them as well
Workaround Reported
 Topic: IsNull() from Excel data issue
sriven786

Replies: 2
Views: 466

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 21, 2017 1:01 pm   Subject: Re: IsNull() from Excel data issue
Check with the system whoever is creating the excel if they are correctly populating the NULL Values (or Add Constraint <> '<NULL>' and see if the data is getting Filtered out by the const ...
Resolved
 Topic: if statement problem
sriven786

Replies: 14
Views: 1131

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Dec 19, 2017 10:24 am   Subject: if statement problem
Thanks, looks like the Stage variable defined as VARCHAR(255) in this case.
Resolved
 Topic: if statement problem
sriven786

Replies: 14
Views: 1131

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Dec 19, 2017 9:04 am   Subject: if statement problem
Tried running simple DS Job with below 2 Columns
Hospital_ProductTypeID,Ancillary_ProductTypeID
3,2
1,8
3,6
7,2
7,7
And it worked as expected.
"Hospital_ProductTypeID","Ancillary_ProductTypeI ...
 Topic: Issue with left justified column with spaces in fixed length
sriven786

Replies: 3
Views: 560

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Dec 18, 2017 1:27 pm   Subject: Re: Issue with left justified column with spaces in fixed le
Please provide your Output File Format

Spaces between columns: This field is only active when you select the Fixed-width columns check box. Contains a number to represent the number of spaces used ...
 Topic: Custom Routine Issues
sriven786

Replies: 5
Views: 928

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Dec 08, 2017 8:32 am   Subject: Re: Custom Routine Issues
Check below link and see if this is of any use for Custom Routine creation:

https://blogs.perficient.com/delivery/blog/2017/05/26/removal-of-special-character-using-routines-in-datastage/
 Topic: Date Conversion
sriven786

Replies: 3
Views: 752

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Dec 06, 2017 8:40 am   Subject: Re: Date Conversion
Similar post on Date Validation, Please take a look and try

http://www.dsxchange.com/viewtopic.php?p=256967
 Topic: Batch ID in Datastage
sriven786

Replies: 19
Views: 1751

PostForum: General   Posted: Tue Dec 05, 2017 12:14 pm   Subject: Batch ID in Datastage
As mentioned, DataStage doesn't a feature called "Batch ID." In my previous project, we used to generate Job_Id whenever the Job Sequence starts and use log that id to Job Table to track the Job star ...
 Topic: Batch ID in Datastage
sriven786

Replies: 19
Views: 1751

PostForum: General   Posted: Tue Dec 05, 2017 8:25 am   Subject: Batch ID in Datastage
If you are looking for Id generation, there are several ways, You can generate taking the Max_Id + 1. What's the purpose of this Id in your Table?
 Topic: Schema reconciliation detected a size mismatch for column
sriven786

Replies: 14
Views: 2694

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Nov 29, 2017 8:17 am   Subject: Schema reconciliation detected a size mismatch for column
Any Idea why Datastage is treating as DECIMAL(31,0) when casing as DECIMAL(31,5) and defined as Decimal (31,5)?

Also, Can you make sure that the order of the columns are correct and Just View Data ...
Resolved
 Topic: EBCDIC - multi copybooks, recordId and link col err
sriven786

Replies: 9
Views: 1175

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Nov 27, 2017 12:06 pm   Subject: EBCDIC - multi copybooks, recordId and link col err
looks like you have successfully imported the layouts and trying to read a Mainframe File with Multiple layouts. If Yes, please check with mainframe team whoever is creating how to Identify the record ...
 Topic: using SQL in routine
sriven786

Replies: 7
Views: 728

PostForum: General   Posted: Mon Nov 27, 2017 9:46 am   Subject: using SQL in routine
Try running with Double quotes

db2 -x "select colum1 from schema.table where colum2='abc'"
Resolved
 Topic: EBCDIC - multi copybooks, recordId and link col err
sriven786

Replies: 9
Views: 1175

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Nov 27, 2017 9:17 am   Subject: Re: EBCDIC - multi copybooks, recordId and link col err
Ask your mainframe support person to do num off std and then download again so that numbers on left side will go off and make sure that 01 level record starts at 8 position.

I have removed the line ...
 Topic: Schema reconciliation detected a size mismatch for column
sriven786

Replies: 14
Views: 2694

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Nov 22, 2017 8:04 am   Subject: Re: Schema reconciliation detected a size mismatch for colum
try running the same query in Toad (Outside Datastage) and see if you are getting the same value or not for below example you mentioned:
The source value in DB is 0.45 the value coming out is 0.00 ...
Resolved
 Topic: Issues when sending attchments through datastage email
sriven786

Replies: 11
Views: 1016

PostForum: General   Posted: Thu Nov 16, 2017 2:33 pm   Subject: Issues when sending attchments through datastage email
Thanks to chulett as it's already known issue Smile
 

 Jump to:   



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