DSXchange

Installing PX to develop is generally simple - insert your product CD and enter the relevant licensing information.
What specifically is your problem?

Where are these statistics coming from? Without a frame of reference it is impossible to do anything with these stats. What do you want to get out of them?

Where Nvl() is being called isn't quite as important as fixing the code in the user-written function!

Where in the job is your trim code? In a stage variable? A derivation? It is more efficient to use the function "In.YourString[2,999]" to remove the first character from a string in DataStage.

Does it mean if you remove this one line then your program compiles and runs without a problem?

The object code for you job thinks that you have a "Nvl" function (and it does exist in your manager's "routines" section) which has invalid code. The Phantom part of the error doesn't mean anything in particular, DataStage uses that term for background processes. Most likely you used Nvl somewhere ...

That is odd, since I know I've used that method before. You can issue a command "DROP SCHEMA alfa_stg_dev;" from TCL to drop the schema (you should be able to do this when logged in as your DS administrator).

If you set 191 as the delimiter then it will not be part of the data. Are you sure of your source data file format? Perhaps you could look at it with a binary editor on Windows or od on Unix.

I don't know where that character is coming from. Use the same debugging method as listed earlier, just output to a temporary sequential file the result of to see what the ASCII value of the first character in the string is.

I wish you had stated that you wanted to re-create that project; then I would have recommended another approach. 1. Create a new project 2. Copy that new project directory and its contents from UNIX to the name/location of the original project that you wanted to delete 3. go back to TCL and "COPY FR...

Yes, there is a way to do this; but I wanted to make sure that the directory is gone at the OS level before suggesting this approach. If you enter TCL from Unix or enter the command interface in the Admin tool you can issue the command "DELETE UV.ACCOUNT {ProjectName}". This is not normal correct wa...

If your client supplied you with a template you should know the layout. The CFF stage will only help you in this case if the data came from something like a COBOL program, which generally doesn't issue binary data except for certain computational fields. What sort of binary data does the file contai...

The multi-client manager works like a charm. The admin id that is being asked for is a local user on the client machine with administrator access and not one on the server machine.

This sounds like you deleted the physical directory from Unix first and then attempted the deletion from the Administrator. Does the Unix directory for the project still exist?

Using "CLEAR.FILE RT_LOGnnn" is not necessarily a good solution; since this will also remove the normal purge settings. Best is to set the purge settings to your desired value so that the log files don't grow to untenable sizes. ...I am unable to clear it by the clear job log option in director.. Th...

DataStage has no problem using a delimiter such as ASCII 168. From your example it isn't clear what your actual source file format is like. Does the source file have a delimiter of char(168) between the columns or a delimiter of char(191) or a mix of both? You can be certain of what DataStage "sees"...