DSXchange

Supply DSJ.ME in quotes.

Its in the sequence job. Its called the "Execute Command Stage"

To make it even more easier you can right click on your stage variable, choose "Stage Variable Properties". You will see your stage variable name and in the second colum where it says Initial value. Call that function. This way the initial value of the stage variable will be set to whatever is in yo...

I was afraid of that. Anyways, thanks for confirming it.

Its basically a simple question, How to comment out a huge block of code without putting stars before each and every line. I am looking for something synonymous to /* All of the these lines are comments */ in a C program. Does such a thing exist for a Basic program

Cool, learnt something new today

Use the following routine in the initial value of a stage variable. Function GetMaxDbValue(Arg1) ShellType="UNIX" Command="cat ":Arg1 Call DSExecute(ShellType, Command, Output, SystemReturnCode) Ans=Output<1> Where Arg1 is the fully qualified path of your text fil...

Or if this is not the complete routine and the code that you have shown is part of a subroutine then Return will pass the execution back to the calling block. I still dont get the semicolon, is that correct systax guys?

ArndW wrote:The DSParams lookup will show the project level default settings, but jobs can override this at runtime so that value may be incorrect.

O yea thats correct. Did'nt pay attention to that. Thanks for the clarification ArndW.

Glad you came back with the solution, it will help others in the future.

You dont need access to the the administrator. You can just go to your log, the second entry will have all the environment variables. You can see the value of APT_CONFIG_FILE.
You can also go to your Project home directory and do

For ease of mainteneance go with the GUI structure, i.e, three lookups on the same hashed file with YOU, MY and OUR keys fromy our source. If you do decide to go with your own custom routine, provide enough annotations and description on whats going on in the job.
My 2 cents.

bkerebel wrote:Call DSFatalInfo(xxx, yyy)

I have never heard of that function, you sure it exists

Additional error messages would help. Did you try setting it back to "generated sql"? See if that works, once you get that part working then you can analyze how different is your sql and the generated one. Analyze in regards to any syntax or data type conversion being done.

Swades, append www before dsxchange in your website address. This way it will take us directly to the page and not to the login page.