DSXchange

One output link per error, then funnel the errors together to one stream for the error log. This is a common approach. We have one job at this site with many columns and each column can have multiple errors, so with one input link to a transform stage we have at least 50 output links and this job ha...

Craig - I think I was thinking in German and wanted to write "Moderatoren" but managed to miss-spell even that simple word.

try executing "rsh YourRemoteHostName ls -al" at the command line while logged into the system under the DataStage id. Does it work? If not, what is the error message?

If you comment out the DSOpenProject() call, does the routine compile correctly? Is your path to the dsapi.h file correct and does that actually contain the DSOpenProject() definition?

Your "ulimit" value is set incorrectly at runtime for the DataStage processes. Usually this is reset to a higher than default value in the "dsenv" file. Is this a new installation? Does your dsenv file contain a ulimit setting? What UNIX flavor are you working on?

In that case, how would you define the sum of that timestamp? For example, what would you expect to be the answer when adding
"10/21/2010 2:57:55 PM" and "10/21/2010 6:57:55 PM"?

Moderatore - Please more to PX forum

If you have a lot of Varchar columns with bounded values where the actual contents don't consume a lot of that length (i.e. VarChar(128) where usually only 10 character are used), then you might save on I/O by making those column unbounded. Apart from that, writing to a Dataset is going to do nothin...

What is value of the column after the second quoted string field, my guess is that you are seeing

BARTON E",

.

Use MonthFromDate() to get the month from a date, YearFromDate() to get the year from a date and then a bit of simple subtraction and logic to get the delta months between two dates.

UNIX scripts can be run in parallel. What we cannot guess is exactly what SQL you are using in your script and if that might have problems running in parallel. Can you specify "for read only" in Teradata SELECTs so that no update locks are taken?

This would be normal, I remember seeing the size of my first SUNOS "Hello World" program and almost having a heart attack, it seems that all of the libraries are inserted into the object code rather than being linked to at runtime.

No problem: cut and paste the following line
to your notepad and save it as "TESTFILE.COB". That is your CFF file for testing the COBOL FD

Sequential files are 1 writer - N readers. You cannot have two processes write to the sequential file at the same time. When you do that, the process the closes the sequential file last will overwrite the other processes' information. This has nothing to do with server or PX technologies but is fund...

If your timestamp values are just number of seconds logged in, then you should be able to sum up the values without conversion. Have you tried it?

The command would be "rsh" or "ssh" and the exact syntax depends on your flavour of UNIX. Your userid must also be granted rsh or ssh priveleges on the remote machine so you will need to speak with your sysadm to ensure that permission is granted.