DSXchange

It makes them more 'Server like' and as Ernie notes, they work thru a single connection in the same unit of work, so issues like parent/child loads can be simplified as a new child record would be aware of a new parent record inserted in the same transaction.

Why a routine? Why not a simple Server job?

From a routine, you'll need to leverage sqlplus from the command line using DSExecute().

Be very careful if you go that route and manually edit the dsx. It can take only the simplest of errors to completely destroy a project. I know... been there, done that, got the t-shirt. Had to get bailed out by the awesome Karen Powers, if that means anything.

No-one can know the answer to that except you and yours. Did anything 'unusual' happen five days ago? System crash, ran out of disk space, anything?

I've moved your post to the proper forum.

You match the target length.

LOL... don't think that's the question being asked. I'm assuming they are asking if there are differences in those variables when compared to their counterparts in ealier releases.

Some good information on istool from Andy here.

As I'm assuming this has nothing to do with ProfileStage or IA, please repost this in the proper forum - the Enterprise Edition forum.

I would assume an ODBC text driver could read the file and pass back only certain columns but under the covers it would still read each record in its entirety. I don't see the need to complicate this, however, read the record and only pass along the columns you need.

Read the records as one long string field, you can parse out the individual elements from there especially seeing as how the first 'column' has the total number of columns in it.

poorna.ds wrote:sqlplus: not found

Help it be found, use a full path to the executable or add where it lives to your $PATH variable. Standard 'Command Line 101' stuff.

Split from this topic.

Compared to what, earlier versions? What O/S? Several were mentioned in the linked post.

The warning is telling you that your null field value must match the field's fixed width. What does that suggest to you?

I have no clue, what do the installation instructions say? Is that a supported compiler? Why not ask your official support provider for help?