DSXchange

This looks like a follow-on post to this one. I think that I agree with Ray's assessment in this case. If you don't care whether the interview answers are right or wrong, try this site.

PX allows you to control the "type" of many messages. I suggested that you "deprecate" the warning message and turn it into a normal, informational, one in my original post.

This is done by using "message handlers" in PX.

I'm confused about how buffering mode plays a role here. Ahh, I just reread the post and realized you are using file sets. The Parallel Job Advanced Developer Guide quotes File sets The export operator can generate and name exported files, write them to their destination, and list the files it has g...

Are you sure that you need a Windows format file, as your backend is UNIX?

Please post your StringToTimeStamp derivation.

Even though I don't know the problem I do have a question - did the "test" project get created successfully? Also, could you try to create a project from the UNIX command line using dsadmin -domain <domain> -user <user> -password <password> -server <DataStage server> -createproject <project name> [-...

Hello and welcome to DSXChange.

First try to isolate the error. Convert your decimal to a string and put the output into a file or a peek stage. Does it convert correctly as you expect? If yes, then please post a couple of sample values and also your StringToTimeStamp() conversion statement.

Something is odd here, directories/hashed files with "QS" are used for the V8 quality stage, I don't see how MQ could utilize them. Is the project directory path full?

2Ksaint - no need for a second thread, you already have one addressing this issue at this location.

This message normally will not appear unless you modify your stage and change the Stage -> Advanced tab and specifying "export". Did you do that?

No, you are not wrong. Which is why I ended up using a transform instead of the column generator to use the current time.

Question - you posted in PX but stated you are using Server jobs. Which is it? The answers are different in each product. The RT_LOGnnnn hashed file IS a table. It does not reside in a schema on an SQL database as you assume, though. The DDL is not published officially, but as Ray has already pointe...

It would seem that your environment isn't set up completely and the library is missing.
1. I'm on V8 so my libraries are in different positions, but you can use "cd $DSHOME\.." and "find . -name dsdb2.so" to get the directory
2. Ensure that this directory is part of the LIBPATH environment variable.

I thought I could do that once as well, but the column generator doesn't work that way, so I ended up reverted to using a transform stage in PX and getting the system date and time "the olde way".

Anju, Ray's response is part of Premium content, which you can view if you were to sign up for that relatively inexpensive membership. Even though the message is not currently viewable in it's entirety, the portion that is visible gives you the clue on how to solve your problem. Basically, a "\n" (U...