DSXchange

I had to load a SQL Server datetime field once and found that setting the target column's data type as Timestamp(23,3) worked. So it will expect the data to be in a format like YYYY-MM-DD HH:NN:SS.SSS. In a Transformer stage derivation you can right click and choose from the various built-in date/ti...

For your second question, I did not think you could put precision/scale into decimal for IsValid(). The description of the function does not go into much depth or provide many examples. Have you tried IsValidDecimal()?

I'm going to have to guess on this one... The SQL looks OK. Maybe the ODBC doesn't like the convert function. You could try moving that little transformation to a stage before the ODBC stage.

Welcome to DataStage! Parallel jobs have a lot of date and time functions built in. They are documented in the appendix of the Parallel Job Developer's Guide. You should have it on your client as a PDF under the Start menu... documentation icon. Check out this one for comparing two timestamps: Secon...

Try moving that select statement into the select statement for the stage (not a generated SQL statement), or moving it into a select statement in a separate Oracle stage.

You can also open the derivation editor in a Transformer stage, right-click to choose it out of the DS Macro... list, and copy it to your clipboard from there. If you paste it into a filename then you have to add the # signs yourself.

On the "Invalid SQL data type" error, you may actually have a data type in the job design that SQL Server can't handle, or you may need to upgrade your DataDirect ODBC drivers to the newest 6.1 release. Upgrading drivers resolved these same SQL Server / ODBC errors for me. On the "COU...

According to the product guides:

psort
Yes, "p" for partition sort.

tsort
And, "t" does not appear to be documented what it stands for. We can speculate until the cows come home... Anyone know if it's documented?

I agree--don't change the uid=0 value to some other value. I think it could mess up your whole server. If you screw up as the root user, someone will take root user access away from you, most likely for good. Are you really just wanting to change ownership of some files from the root user to some ot...

Double quotes work also.

So do wildcards. cat filename_*.txt.

Privacy is a big concern everywhere. In healthcare especially, at least in the U.S., there are more regulations around protecting privacy. Search on the "HIPAA Privacy Rule." Personally, I'm more concerned about learning and applying the rest of the tools in the Information Server suite (b...

priyadarshikunal wrote:I think it is 01-01-1970.

Close... in Server jobs the zero date is December 31, 1967.

viewtopic.php?t=143412

What statement is in the Before SQL?

This won't be apples to apples, but here is what I have on AIX 6.1 with v8.7, lslpp -l command output for xlC compiler (stick with that; not g++): xlC.adt.include 11.1.0.0 COMMITTED C Set ++ Application Development Toolkit xlC.aix61.rte 11.1.0.0 COMMITTED XL C/C++ Runtime for AIX 6.1 xlC.cpp 9.0.0.0...

The manual does say 5 bytes for Time by itself and also says 5 bytes for Time with Microseconds. There are only 86400 (60 * 60 * 24) seconds in a day, which in binary, only requires 17 bits to store, which rounds up to 3 bytes. My guess is that the manual must be wrong for Time by itself. It seems t...