DSXchange

Is your date column declared as VarChar() or DATE? I assume it is VarChar, as your SQL does a to_date() conversion on it.

...It is that wrong you consider and It should not be a false assertion as you yelled out. Not only that, the VLIST output of DSD_GenRuntime.B may tell you teh functionalities in a lucid manner. Besides that, DSD_CompileJob.B does call this Runtime program. Please verify that... Actually, I was cur...

In your first test, the date is the 5th parameter, in the second it is the 3rd.

[quote="ag_ram...directly calls one of the Run time Interfaces (the DataStage BASIC compiled Subroutines starting with name DSD_) DSD.GenRuntime.B (The DataStage Job Compiler internally)...[/quote] The only compiler in the DataStage Engine is the BASIC compiler, it is invoked with the "BASIC" comman...

Ok, time to [/fun], otherwise veera24 will think the worse of us.

veera24 - I can't explain your log contents since I don't know what they are. Note that the client software often displays characters that it cannot display correctly as a "?" question mark; you need to differentiate between an actual question-mark and a non-displayable character. I seriously doubt ...

It looks like the values of all 6 parameters are given as non-numeric. Which of your columns is defined as numeric?

pradeep_nov18 wrote:...i want to know how virtual dataset impact on dataset wat error we can face in real time regarding memory...

If you run out of virtual memory you can get a number of errors, ranging from "no space" to "unable to allocate memory".

minhajuddin - if the eCase isn't resolved then I don't understand why you are surprised that you can't pass a single quote in a parameter.

What was the return value from your job activity?

Ok, I fixed it.

[DataStage][/Rules]

do a "reset" of the job and check the job log for an entry starting with "from previous run..." and you will at least find out which signal caused the job to abort.

Yes, you can use the XML Output stage to feed an MQ Connecter.

[quote="veera24... Before, make sure that there is no '?' symbol in it because I've faced the same problem long back. usually UTF8 wont support other usual symbols....[/quote] I've never had probems with other usual symbols and the Question mark character is definately supported in UTF8. Could you e...

Download the UniVerse System Description and read the chapter on UniVerse File Structures. Some of the are no longer supported in the DataStage server Engine but it will give you a good idea of where to start your experimentation.