DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 21 matches
Author Message
Resolved
 Topic: Issues when sending attchments through datastage email
sriven786

Replies: 11
Views: 105

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
 Topic: ODBC Connector Multiple update Queries
sriven786

Replies: 11
Views: 213

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Nov 16, 2017 2:31 pm   Subject: ODBC Connector Multiple update Queries
User is using Datastage 11 on Unix and ODBC connector stage on Unix did not have the option of User Defined Sql.

Job Type: Parallel
OS: Unix

Note:Not sure how to attach image. so could not ...
Resolved
 Topic: Issues when sending attchments through datastage email
sriven786

Replies: 11
Views: 105

PostForum: General   Posted: Thu Nov 16, 2017 1:30 pm   Subject: Issues when sending attchments through datastage email
try creating the File with Record Level Delimiter as : DOS Format and try sending as email attachment. (Format Tab: Record Level Right Click and Format as Dos line terminator)
 Topic: ODBC Connector Multiple update Queries
sriven786

Replies: 11
Views: 213

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Nov 16, 2017 12:55 pm   Subject: ODBC Connector Multiple update Queries
Answer is still the same, only a single DML statement is supported.
yes. After sql can support multiple statements
Resolved
 Topic: Issues when sending attchments through datastage email
sriven786

Replies: 11
Views: 105

PostForum: General   Posted: Thu Nov 16, 2017 12:53 pm   Subject: Issues when sending attchments through datastage email
looks like the file is created in Unix and when run unix2dos and then attach, file is coming properly. Try doing unix2dos and test it.

Please check similar post below

http://www.dsxchange.com/vi ...
 Topic: Remove multiple special characters from leading and trailing
sriven786

Replies: 16
Views: 320

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Nov 16, 2017 12:25 pm   Subject: Remove multiple special characters from leading and trailing
Yes, I tried too and could able to find the first occurrence using the INDEX Function but the issue is to find the last occurrence (May be you need to write a custom subroutine to get the last occurre ...
 Topic: ODBC Connector Multiple update Queries
sriven786

Replies: 11
Views: 213

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Nov 16, 2017 11:36 am   Subject: ODBC Connector Multiple update Queries
Yes. Teradata connector write mode allows for User Defined but not the odbc connector (Only Insert/Update/Delete)
 Topic: Schema reconciliation detected a size mismatch for column
sriven786

Replies: 9
Views: 186

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Nov 16, 2017 8:46 am   Subject: Re: Schema reconciliation detected a size mismatch for colum
Are you Casting while Extracting from Table As suggested below ?.

you can cast it in the extract sql to match the target format

Please clarify
 Topic: Schema reconciliation detected a size mismatch for column
sriven786

Replies: 9
Views: 186

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Nov 15, 2017 8:00 am   Subject: Re: Schema reconciliation detected a size mismatch for colum
Please check below link and try one of the 3 suggested options

https://www.ibm.com/support/knowledgecenter/en/SSZJPZ_9.1.0/com.ibm.swg.im.iis.conn.drs.usage.doc/topics/DRS061.html


There are ge ...
 Topic: Remove multiple special characters from leading and trailing
sriven786

Replies: 16
Views: 320

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 14, 2017 2:27 pm   Subject: Remove multiple special characters from leading and trailing
Thanks for Clarifying the requirement.

I was trying to Convert all Alphabets to some Value and and after that find the First Occurrence of that

But looks like the CONVERT Function is not working ...
 Topic: Remove multiple special characters from leading and trailing
sriven786

Replies: 16
Views: 320

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 14, 2017 9:41 am   Subject: Remove multiple special characters from leading and trailing
Is your Delimiter: ^&

Please clarify.

e.g.: Input Data like: !@##$$Rami^&Reddy*&^%$
Output Data Should: Rami^&Reddy

Tried with Convert as below
Convert(char(10):char(11): ...
 Topic: Schema reconciliation detected a size mismatch for column
sriven786

Replies: 9
Views: 186

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 14, 2017 8:47 am   Subject: Re: Schema reconciliation detected a size mismatch for colum
Check the data type in the database table.
Check the data type in your job's metadata.

If you're using a Connector stage, change the "Fail on type mismatch" property from Yes to No.
Resolved
 Topic: Date format issues
sriven786

Replies: 2
Views: 71

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Nov 13, 2017 1:14 pm   Subject: Re: Date format issues
Note: Assuming that your Input date all have >2000 (20th Century)
Otherwise, please request them to provide with Century part also if you are expecting dates before 2000
Resolved
 Topic: Date format issues
sriven786

Replies: 2
Views: 71

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Nov 13, 2017 12:58 pm   Subject: Re: Date format issues
Please refer below link

http://www.dsxchange.com/viewtopic.php?p=388928

I guess you can use StringToDate(Trim(DSLink2.File_Date),'%dd-%mmm-%2000yy')
 Topic: ODBC Connector Multiple update Queries
sriven786

Replies: 11
Views: 213

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Nov 13, 2017 10:38 am   Subject: ODBC Connector Multiple update Queries
User Defined SQL is disable if we use ODBC Connector as Output.

I guess the user is trying to use Update statement and as per documentation, only 1 update statement can be executed

Please clarif ...
 

 Jump to:   



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