Search found 320 matches

by mydsworld
Fri Jul 11, 2008 1:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC Connector error/warning
Replies: 4
Views: 1088

Does anyone have answer to this.

Thanks.
by mydsworld
Wed Jul 09, 2008 1:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SAP BAPI stage query
Replies: 1
Views: 1391

SAP BAPI stage query

I am using DataStage SAP packs.I need to call a RFC enabled function module.I need to pass some input parameters to it and capture the results from the call.Based on the result I need to do some other processing. Since I found BAPI stage can have either input or output link, so how shd I use the BAP...
by mydsworld
Tue Jul 01, 2008 8:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC Connector error/warning
Replies: 4
Views: 1088

Even if I use STRING(min=0,max=24,charset=UTF-8) for target type, I get another error for making it STRING(min=0,max=72,charset=UTF-8) for target type.
So, not sure what is the problem.
by mydsworld
Tue Jul 01, 2008 1:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC Connector error/warning
Replies: 4
Views: 1088

ODBC Connector error/warning

I am using ODBC connector stage, I am getting the following warning trying to do a 'Insert after Delete'. ODBC_Connector_7: [IIS-CONN-DAAPI-000067] Schema reconciliation detected a size mismatch for field XFWNO. When moving data from source field type STRING(min=0,max=8,charset=ISO_8859-1:1987) into...
by mydsworld
Mon Jun 30, 2008 2:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP error
Replies: 8
Views: 2714

Also my username for FTP contains '\'. Can this problem be due to that.Is there any way to debug. I am able to FTP from the remote server by telneting into the DS server.
by mydsworld
Mon Jun 30, 2008 2:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP error
Replies: 8
Views: 2714

I am trying to FTP (get) from a Windows machine. Has anyone found similar problem ('is not a valid remote file') earlier.
by mydsworld
Thu Jun 26, 2008 2:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP error
Replies: 8
Views: 2714

Yes,same userid & password has been used in the job.
by mydsworld
Thu Jun 26, 2008 2:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP error
Replies: 8
Views: 2714

I can FTP the file from outside so the userid/password I assume is fine.
by mydsworld
Thu Jun 26, 2008 2:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP error
Replies: 8
Views: 2714

FTP error

I am trying to FTP get a file from remote server.The file resides in the FTP user home directory.I can get the file from FTPing from outside DS.But can not do the same from DS.

Getting error :

FTP_Enterprise_0: uri : ftp://abc.gty.com/Book1.xls is not valid remote file.

Please help.
by mydsworld
Wed Jun 11, 2008 10:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: After-job subroutine
Replies: 6
Views: 2355

After-job subroutine

When I write after-job subroutine, do I need to open a job handler for the job or skip that as the job is already open.

Also, how do I access other components (stage,links etc) used in the job.Is it possible to pass a stage variable (derived in a transformer) to a after-job subroutine.
by mydsworld
Wed Jun 11, 2008 10:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Switching between sequence and job
Replies: 22
Views: 7006

The Userstatus is not being set from J1 correctly.What could be the problem.Can I not set Userstatus in parallel job using server routine that calls DSSetUserStatus()
by mydsworld
Wed Jun 11, 2008 9:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Switching between sequence and job
Replies: 22
Views: 7006

The Userstatus is not being set from J1 correctly.What could be the problem.Can I not set Userstatus in parallel job using server routine that calls DSSetUserStatus()
by mydsworld
Wed Jun 11, 2008 9:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Switching between sequence and job
Replies: 22
Views: 7006

I Have my sequence S1 : J1 -> J2 In J1, BASIC transformer, I am forming stage variable (by concatenating fields) and calling my server routine that uses DSSetUserStatus() to set USERSTATUS equal to stage variable. Back in S1,I am calling J2 with J1.$Userstatus as job parameter.But I am getting no va...
by mydsworld
Wed Jun 11, 2008 7:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Switching between sequence and job
Replies: 22
Views: 7006

Thanks for all the posts.

Will try them out. By the way, is there any limit of size for using 'USERSTATUS'. Because if I need to store delimited values in it,it may become too lengthy.
by mydsworld
Tue Jun 10, 2008 8:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Switching between sequence and job
Replies: 22
Views: 7006

Can we use USERSTATUS instead of Routine to capture the delimited values.