DSXchange

The error message suggests that the generated source code file (RT_BP12/JOB.1493257848.DT.1348733279.TRANS1) has been truncated by something (such as an operating system disk bad spot, disk utility, etc.)

It might be interesting to compare how many machine operations each requires. 0001: FUNCTION TEST(COUNTRY_CD) 0002: 0003: * Conditional statement 0004: If COUNTRY_CD = 'c' 0005: Then 0006: Ans = 2 0007: End 0008: Else 0009: Ans = 0 0010: End 0011: 0012: * Conditional expression 0013: Ans = I...

Define "performance".

Only it's not a log file - it's a log table (hashed file). So you have no easy mechanism for browsing it from the operating system level. It is always created in the project directory - you are given no control over this - though you can move it later (subject to a number of caveats, not least of wh...

Totally invalid default values (such as "" for an Integer) won't even get past the requesting parameter values phase.

You might find this piece (in the FAQ forum) on DataStage architecture interesting.

There's no Lookup stage in server jobs, but the idea is a sound one. I don't know whether the other posters' assumption that you're using Oracle is a correct one. However, no matter what the stage type, if you have a list of keys, supply only those keys. Use user-defined SQL of the form DELETE FROM ...

The way that dates are handled is inconsistent between stage types, so you need to learn what your particular stage type expects. Some expect internal DataStage format, others expect some definite picture/format to be supplied. Once you've learned the rules by which your stage type plays, you can al...

You're right, there's no SQL Server or Sybase provided. Choose DB2 or Oracle from the drop-down list (step 2 or step 4 in the Wizard). DB2 asks for database name and server name, Oracle asks for user name only. Create the job (you can load the table definitions from anywhere in the Repository, provi...

And...

Can you now see the jobs OK?
Have you updated your administration documentation?

UNIX response, at least initially. To hide the password from ps -ef users, you must employ a shell script, whether you call it from a before/after subroutine, a command activity or a routine. #!/bin/sh # Invoke sqlplus command # Environment variables contain authentication and SQL # A "here scr...

When an Oracle table is created, it is created in a table space (an allocation of disk space). This can be made static, or auto-extending. The default is static, which means you can fill the allocated space. Once it's full, an attempt made to extend it will result in the error you reported. Your Ora...

If the data type is integer, then 0.25 will be read as 0. I dispute that NUM('1-Discount') would return 1. The following test, using DataStage SQL, makes the point. >SELECT EVAL "NUM('1-Discount')" FROM VOC FIRST 1; NUM('1-Discount') 0 Sample of 1 records listed. A similar ...

The internal pointers are 32-bit twos complement signed integers. The most significant bit is used for the sign. That leaves 31 bits for the value. 32-bit twos complement signed integers range from -2147483648 to +2147483647. (Don't forget zero has to be represented.) Why signed? Because it's necess...

Please post the entire message, and read all the information contained in it. Among other things, it reports the name of the stage in which the error was generated.