Search found 8 matches

by vijayk.kumar@target.com
Wed Sep 30, 2009 3:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sparse Look Up on DB2 UDB on Mainframes in PX
Replies: 4
Views: 2435

DB2 Driver Embedded SQL message: SQL0551N "JDBCFFFT" does not have the privilege to perform operation "CREATE IN" on object "DB2T.DSADM.DB2ESQL". SQLSTATE=42501 sqlcode = -551; sqlstate = 42501 Program not bound to database Attempting to bind to the database /apps/Ascen...
by vijayk.kumar@target.com
Wed Sep 30, 2009 2:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sparse Look Up on DB2 UDB on Mainframes in PX
Replies: 4
Views: 2435

Hi,

Yes Normal Look Up, Joiner works fine.Sparse look up is creating a problem.

Regards
VJ
by vijayk.kumar@target.com
Tue Sep 29, 2009 10:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sparse Look Up on DB2 UDB on Mainframes in PX
Replies: 4
Views: 2435

Sparse Look Up on DB2 UDB on Mainframes in PX

Hi All,

We are facing some issues when doing sparse lookups on DB2 DB on Mainframes.

The DB user is unable to Bind the DB.

Can any one please help on this.

Regards
VJ
by vijayk.kumar@target.com
Thu Jul 12, 2007 10:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Export Job creates 1KB file
Replies: 9
Views: 3652

Hi Ray,

I am able to Open the Job and changed the stage queries and executed. It is working fine.

But to Migrate these Jobs to test M/c It is creating a problem.

Regards
vijay
by vijayk.kumar@target.com
Thu Jul 12, 2007 5:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Export Job creates 1KB file
Replies: 9
Views: 3652

Hi Ray,
Good Morning.

I am able to open the Jobs and able to execute.Previously i am able to export those jobs and put different servers.

Regards
vijay
by vijayk.kumar@target.com
Thu Jul 12, 2007 3:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Export Job creates 1KB file
Replies: 9
Views: 3652

Hi,

I am only selecting the Job Design.
If i select other check Box like Tables, Job Design I am only getting Table information. There is no Job Designs in the file. I checked to export some other jobs also , But the result is the same.


Regards
vijay
by vijayk.kumar@target.com
Thu Jul 12, 2007 2:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Export Job creates 1KB file
Replies: 9
Views: 3652

Hi,

I am taking export of Individual Job Component. All my Jobs In the same project even i tried to export gives the header file only.
by vijayk.kumar@target.com
Thu Jul 12, 2007 2:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Export Job creates 1KB file
Replies: 9
Views: 3652

Export Job creates 1KB file

Hi All, Exporting of Job Design creates a 1KB file for the my project.But when i tried to export another job from different project for the same server , I am exporting the Job Design. My export file looks like BEGIN HEADER CharacterSet "ENGLISH" ExportingTool "Ascential DataStage Exp...