DSXchange

Eric

Have you set the code page in the job design, not the OS where the DataStage Engine lives?

What stage are you using?

Eric

You need to use the Hostname.
You could always add an entry into your local hosts file to resolve hostname to IP.
Otherwise you would have to fix DNS.

Eric

You love windoze RG then

Press here

Eric

Eric We wrote parallel routines with the following options 1. Used object as object-type 2. Given External routine name 3. In Library path, we gave the path of the object file(.o) 4. In Type, we gave "External Function" Thanks Sai The makefile etc looks good. when you created the routine ...

Eric

Did you build a static or dynamic library?
What compiler and compile arguments did you use?
Did you follow the TrxExternalFunctions examples?

Perhaps you could post something about how you compiled you external routine?

Eric

If you've installed DataStage with NLS then you'll have to set a locale/code page rather than 'None' as all input files with have a code page.
Have you tried using the installed default?
What problems do you have using the NLS settings?

Eric

newsaur wrote:To Eric: Yep, DB2 allows inserting to a view under some conditions.

I beleive the condition is that the View has been created based on a Single Database Table.

Eric

As I remember. the rules of SQL say You can't INSERT into a VIEW that is made from multiple tables. Is this still true?

Eric

Ah, sorry

I don't beleive that "/" is a permitted value in the connection parameters for DB2 on Z/os. The "OS/390" is a default value for the parameters which are only relevent for Z/os DB2 connections.

Eric

Yes Ray, you must complete the Name of the DB2 'collection' and 'location'.

yakiku, talk to your OS/390 Administrator to find the correct values.

Eric

I think each object library you want to create should have it's own parallel rountine definition in your DataStage project. You can then reference the different methods though it's defined parallel routine reference.

Eric

There is also the USS option? This allows PX job to run directly on the MainFrame (within a USS environment)

Eric

Try looking at the examples on your DataStage client install Disk
[ Samples\TrxExternalFunctions\AIX ]

Eric

Code: Select all

SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by index-id constrains table table-name from having duplicate rows for those columns.

Eric

Have you tried -> "right click on the palette -> customize -> Reset to factory default"

Search found 253 matches