DSXchange

chulett

So what happens if you either try launching it in the expected shell:

ksh ./GetFile.ksh

Or add this to the top of the script:

#!/usr/bin/ksh

chulett

Like that but it looks like you have the "Disable BBCode in this post" enabled. Edit the post, uncheck the option, preview and see if that fixes it.

chulett

yollsonlegrand wrote:The probleme is that, after seting up environment parameters(server_name, UserId, PWD) connexion to database in administrator and calling this in DB2-Stage like this: #$server_name#, #$UserId#, #$PWD# , runing the Job failed.

Failed how?

chulett

Then it seems it is time to ask that the topic be marked as Resolved using the big button at the top of the screen.

chulett

True, not sure what I was thinking there.

chulett

They didn't say there was. The square brackets are the substring operators, so they showed how to take 2 characters from a field named STR starting from the 6th position.

chulett

You would need to have your admins install the Open Client software for Sybase. That and make sure it is a supported version, from what I recall 12.0 and 12.5 are supported.

chulett

StringToDate.

chulett

The Pivot stage has a "Help" button that nicely explains how it works, suggest you give that a shot and come back with specific questions if you still have any.

chulett

Probably, but U hasn't been here for awhile.

chulett

Enable checkpoints in the Sequence job, that is their whole purpose in life.

chulett

Not in PX, no.

chulett

Pivot stage.

chulett

Use the client from the "lowest" version to access all versions and you should be fine. For example, we access 10g and 9i with a 9i client.

chulett

Either pass the "date time" in as a Job Parameter and #include# it in the filename or create a static filename and rename it after job to include that information.

Search found 42189 matches