DSXchange

And what is the format of this Varchar? Is it YYY-MM-DD?

OK, but where are you specifying your buffer size and timeout in these two stages (which I think you can't)? Are you referring to the buffer size and timeout values as part of the job attributes? Do you have IPC stages? Just a bit more information from your side and you might get an answer you can u...

And what have you tested, gshivnani? I trust you didn't post first before trying to localize the problem. I just wrote a short job, column generator creating a varchar(32) string with the constant value "2005-10-01" and a transform stage using the StringToTimestamp conversion and it worked. As I ind...

I figured he's got so much data that it needs to represented in a big font as well

Buffer Size and timeout ... looks like you are using a named pipe or IPC stage. Is this correct?

If JoinCombine_Master_Ref.TrailerTimeStamp is a string datatype with the YYYY-MM-DD format, then I recommend using the simpler

Gul,

lots of people here could help if we knew more. You are seeing and showing us the text representation of an invalid TimeStamp value. What is the last stage where the TimeStamp was (verifiably) correct and what did you do to it thereafter?

Doesn't happen to me.

Try reproducing it very simply. Create a job that is not multiinstance that is very simple and is not multiinstance. Export it, delete the original job and re-import it. Is it now multiinstance?

To DataStage server jobs, all variable type are the same (it's a very egalitarian system) and the maxium length is pretty much limited to the available virtual memory of the process running the job. The limitations on datatypes come when you are writing to a specific system and stage. So whatever th...

Are you wanting to get the sysdate from the database or from datastage? Subtracting 23:00 hours from the current date and time and returning the result in the form ofYYYY-MM-DD HH:MM:SS can be achieved as follows: Routine MimiDateSubtract EQUATE TwentyThreeHours TO 23*60*60 ;** number of seconds Dat...

Did a quick test with a date format of %yyyy%ddd and it worked in PX, so if he can add that pesky 1900 to the number he should be set.

Hello Kish,

I hate to have to correct both Craig and Ray; but they neglected to mention in their posts that it is important to make a backup before starting your work.

Nosferatus, the good news is that you know what format you have; the bad news is that you don't have a true Julian date representation in the form of number-of-days-since-some-starting-point. You can correctly read this by using the format string "%yyyy%ddd" once you convert the year portion to 2nnn...

When you create a project a number of actions are done, but the most important one from your point of approach is that the DataStage schema is created and the appropriate master pointers point to the directory where the project resides. I think it might work if you were to just copy the project dire...

I tend to disagree with Vincent on hashed files; good and fast DS ETL implementations make use of hashed files for such purposes as changed data detection and efficient lookups; reloading them daily from a database system just to not have any any permanent data stored in hashed files defeats their p...