DSXchange

I'm not at a system where I can check, but I seem to remember that Oracle VarChar() and VarChar2() act a bit differently when it comes to padding. Can you try to export a VarChar() column as well and see if it is still padded to a fixed length; I think it might not be.

Have you tried to manually ftp from the command line on your production server? Sometimes FTP is disabled and that might be causing your error.

Sravani - when I look at the datatypes available to me in stages and when creating a buildop I see "float" available everywhere.

No, the field which triggered the error is not returned from the database, so it cannot be displayed, just the standard SQL and error codes.

In versions prior to 8 I would always have recommended a re-install as being quicker and safer when it comes to the IP-Address and node name. It might be possible to change this at version 8 but I haven't tried and would still tend to recommend re-installing since you don't have to back anything up.

V - What do you mean by "not use the system's resources"? Shared containers are loaded into a job's executable at compile time. In server jobs, the code for routines is not loaded in at compile time, links are created and whatever version is locally catalogued at runtime is executed.

On sites with multiple DS instances there won't be a /.dshome file. I would prefer to stick with the simple, time-proven method that Ray suggested, "System(32)".

In your test job, if you do a "diff filea fileb" are they identical?

Normally, a function is passed parameters and returns a value while routines are called with parameters and may change the return value of these parameters. This naming convention is broken somewhat in DataStage, as the "Routines" category actually contains functions. The only true routines you can ...

Such things as:
Domain Management
Session Management
Users and Groups
Log Management
Scheduling Management
Manage Services Categories
Manage Deployed Services
Manage Undeployed Services
Manage Custom Attributes
Configure Service Registry

etc.

No, the two administer very different things and have different front-ends (DS Administrator is an executable on the PC and is installed with the other DataStage clients, the IIS administrator console is a light client on your browser)

ag_RAM - please don't misquote me. I stated Neither compile BASIC code directly I stated several times in this thread that only the nbasic executable compiles BASIC code. If I were to write a UNIX shell script that invokes the c++ compiler then, according to your definition, I have written a compile...

The first parameter for DSGetJobInfo() is the JobHandle, which is returned from the DSAttachJob() call. "DSJ.ME" is a builtin value for the current job, for other ones you need to attach to them first.

If you pass it in as a string and do the to_date() conversion in the SP does it work?

DSD_CompileJob.B has 53 source lines, and calls DSD_GenRuntime.B which has 12987 source lines. Neither compile BASIC code directly. DSD_GenRuntime.B calls the BASIC several times for components.