DSXchange

you can also use before subroutine in job properties


execDos sqlplus -s username/password @filename.sql,>file.log

in filename.sql you can write the delete statement.

i think if you have some directory structure for your file location for windows machine ,need to be changed for unix system

yes their is Readonly "0" flag in DSX (.dsx file), which when set to Readonly "1" and imported, will not allow to run a job from datastage designer but will allow to run in director for that particular user/password.

hope with proper example i have showed you how xml input stage works interpreting xml file to table structure.

you have to use XML Meta Data Importer and xml input stage.

search for forum you will get answer

you use a stage variable where you declared initial value for it as 100 and use dslinkrowcount, which increments for each row processed. you then compare values and use SDK utitlity --->UtilityAbortToLog

please qoute your warning message

hello can you define upper limit for your procedure, like until what date you want your procedure to run say upto say 01-01-2010 in interval of 30 mintues. i have an idea like you define one job with stored procedure stage and call that job from other job using job control and sleep statement, hope ...

Subroutines do not return a value,Not available in expressions.When designing a job you can specify a subroutine to run before or after the job, or before or after an active stage.

you have to create a script that will call your procedure in a file and call it in Execute_Command Stage like

for windows env:(try for unix env)

sqlplus -s oracle/oracle@BIODS @d:\datastage\data\india1\sachin\in\test.sql;

where test.sql contains

begin
test_procedure;
end;
/
exit

hello for writing custom routine you need to check for paticular directory and hash file to delete, i mean to say their should be two input parameter. next is basic code help text. Use the EXECUTE statement to execute DataStage commands from within the BASIC program and then return execution to the ...

my question is that your table contains a column in which query is stored, is this query static i mean to say same query always or dynamic which means that table columns contains different query for each execution, if it is different then how are you populating your columns viewed through datastage.

hello if you are using basic code to execute jobs and have some code in Job Control tab of job then below will help

JobHandle = DSAttachJob (JobName, ErrorMode)


ErrCode = DSSetJobLimit(JobHandle, LimitType, LimitValue)

ErrCode = DSDetachJob(JobHandle)

what is an error message please post it

sorry regarding improper relply, yes the sdk routine UtilityWarningToLog is what you wanted