DSXchange

Use following function in sequence, it may help you StringToDate(input.mystring,"%dd/%mm/%yyyy"): it will give you dd-mm-yyyy DateToString(output.mystring): retun a string in dd-mm-yyyy Sorry, but the above is incorrect in more ways than one. Please read what Ray posted for the 'why' of t...

First we need to note yet again that "08-08-2012" is not a date, it a string - an external representation of a date. So, first question is do you need an actual Date datatype or a String in that specific format?

Oh, I know... I just don't think we'll see any kind of an enhancement to this site in, well... ever. From what I recall, any kind of improvements are supposed to be in the 'new version' of the site that has been in the works for some time now. Hopefully that's still happening.

You could always start to answer that question yourself by checking the documented options for the dsjob command.

Even after all this time, I'm not sure exactly where the cutoff is and I think it can be affected (confused?) by BBCode around the cutoff point. If you want to check a particular post, log out and read it without logging back in as your premium self, you'll see where it cuts off.

Unless you are planning on managing this "SK file" manually, the state file the SKG stage leverages will do all of that max tracking automatically for you after you seed it.

SURA wrote:If you use the Stage variable for that , then stage variable will return TRUE / FALSE only.

If you use stage variable for what "that"? I see nothing that will return TRUE/FALSE in what they posted.

karthi_gana wrote:is it a bug in Datstage 8.5? is there any patch needs to be run for this? or am i missing something?

Questions for your official support provider and it seems like you've got great information to back up those questions to them.

Did you check as suggested?

Are you certain about the record delimiter? A fixed-width file doesn't really need one. If you do a "wc -l" on it does it tell you 1 or something greater than 1?

This was four years ago... why not start your own post and let us know what problem you are having?

A quick google shows a little bit of conflicting information for that primitive type. One reference says: "Boolean fields have one of these values: true (or 1), or false (or 0)." While another says: "A value that can only be assigned true, false, or null. For example: Boolean isWinner...

Out of curiousity, why a VARCHAR 10? What do you see in it when you extract this boolean data? I was assuming you would be dealing with either a 0 or a 1 but it seems that may not be the case.

:!: Please do not run around and find semi-related posts to hijack, just stick with this one (or your other related one) to get your questions answered. I removed this from the older post you found, thought it would work best here. I am having the same issue. scratch disk space is full . here is con...

I would imagine you'd need DataStage to be running on a Windows server for that to work.