DSXchange

[quote="vinothkumar"]Hi,
I have to start a sequence repeatedly if any file arrives at a particular location. I tried to do by using a WaitForFile stage by giving the file name as *.*. It is not working. How can we do this ?[/quote]

did you give the complete path in the file name ??

[quote]
How can I sort data using datastage without using the sort stage?

Can anyone tell me how to use the UNIX sort commond in transformer?[/quote]

you can sort the data in the transformer based on a key

[quote="sambit"]Yeah. I tried the following,


begin schema.stored_procedure_name(parameter); end;

Error- Fatal Error: Invalid close command[/quote]

try
begin
exec stored procedure
end;

[quote="sambit"]Hi, I want to execute a stored procedure as soon as I load the data in a table thru Oracle Enterprise Stage thru Load-Append method. I tried using the close command and after sub-routine options also. None of them is working. I tried using EXEC and CALL options in Close com...

[quote="dr.murthy"]hi,

thanks for respond,i checked all the lengths of the fields,there is no problem at all.[/quote]

do you have any user defined sql in the job???

you can register at any of the websites that offer the test..

i did it here
http://prometric.com/default.htm

vinothkumar,
check parallel job developers guide CHAPTER 58( The Parallel Engine Configuration File)

[quote="sravanthi"]Others are not able to open desinger or run,compile jobs [/quote]

can you post what is happening when they try to log in to the designer???

meaning any login error???

when the option
Final Delimiter = end
then it would look for the "end" after the last column you mention in the columns tab.

if it does not see it, would report a warning in the director and the import would be unsuccessfull..that is what my experience reading sequential files..

on to the client machine???

kld05,
can you post the format tab properties set to that sequential file???

[quote="kld05"][quote="betterthanever"]kld05, dint you get any warnings in the director when reading the file ???..[/quote] No I didn't. It's all green.[/quote] just tested writing 3 columns to a file and then tried to read the same file mentioning only 2 columns in the sequentia...

kld05,
dint you get any warnings in the director when reading the file ???..

[quote="dav_mcnair"]I would like to execute UV SQL via DataStage and not an AIX script. Can this be done?[/quote]

did you try with "UNIVERSE" STAGE in a server job???

i apologize chulett, i was refering to pimmit22043 words [b]all parent jobs are linked to " Sequnce stage " with "ALL" option and next sequnce stage with next set with "ALL" option. when i run the sequnce all the jobs are starting same time ,including child jobs[/b][col...