DSXchange

What is enabled or disabled? For those who aren't at a DataStage client to check, which button or box in which stage are you referring to?

Read the error message in detail and change your format to:

StringtoTimestamp(Input,,"%yyyy-%mm-%dd %hh:%nn:%ss")

You don't need complicated loops or logic, you just need to do your update and commit on the two tables in a single transaction. Are they in the same database (and what database are you using)?

What is a "special record"?

Take things one step at a time, in this case the message ...Mmap failed for the library</product/datastage/projets/0A49_PFPIA/RT_BP1556.O/V0S24_JxTHEXT_Gateway_Extract_Log_Tr_Separateur.so> : Permission denied.. indicates that you have access problems. What user compiled the job, what are the permis...

DataStage will automatically 'loop' through your source. This is a very basic job design, even more straightforward than the examples that you would see in the DataStage training class. Instead of getting a step-by-step explanation from the forum, perhaps you could say what you have done so far and ...

In DataStage server internal dates are integer numbers from a starting date. Internal time is in seconds since midnight. Here is one way: DateTime1 = Date1:'.':((60*60*24)/Time1) DateTime2 = Date2:'.':((60*60*24)/Time2) Delta = DateTime2-DateTime1 Multiply the decimal portion by the number of second...

The amount of work is impossible to estimate with the information given, it would be like me asking you "how long will it take to fix my car" when I haven't told you what it wrong with it. The upgrade depends on many factors: - Hardware (same machine, different machine) - How many jobs of ...

A "fork failed" error is something completely different. If it fails because of insufficient resources it is most likely because the virtual memory space has run out - either it is defined too small or you have run out of swap space.

Rows aren't the whole story, how many bytes per row or per day? Also, the amount of disk capacity required is very dependant upon the amount and type of processing you are doing. Values will be different if you are sorting and repartitioning data, if you need interim datasets or values and what sort...

Typically you will see that the remote mounts aren't visible to the background datastage job. Try a before-job call to the DOS command "df" (well, UNIX command but MKS Toolkit delivers that functionality to you). Does the mount show up?

Does the project show up in the login screens for the Director/Designer?

NLS_LANG is an environment variable that Oracle uses at runtime. This, along with ORACLE_SID and ORACLE_HOME should be set (either directly or through oracle script calls) in your dsenv script file. If it is missing then you need to correct that. The NLS_LANG setting should be determined by your Ora...

Since the record doesn't have any OCCURS DEPENDING ON clauses it is a fixed length file.

What exactly is your error?

Not I.

Could it be a user defined variable?