DSXchange

Hello Craig and all others, Is that the reason why i am not able to use $PROJDEF in my 7.1r1 Datastage version. I am trying to use envi variables with $PROJDEF, it only gives error as invalid charector. Could some one explain the use of userdefined environment tab present in the admin window for 7.1...

Thanks lstsaur,
I have created a batch file and had problems in executing from jobcontrol. So, i tryed calling it from the command stage,it worked. Thanks for your post, it was really helpful.

Hello, I wrote a batch job to execute the stored procedure as suggested by lstsaur and kcbland . I am unable to run it and job is aborting with a message "Attempting to Cleanup after ABORT raised in stage Batch::Batch_SP..JobControl" The code i wrote is OpenPath "C:\Program Files\Micr...

Ray, I am able to run a 'do some thing' stored procedure with out importing SP definition in an ODBC stage, i mapped a dummy coloum to seq file, it is working fine,it too don't have input or output parameters to pass into SP. This problem arrises only when i am using a Do some thing SP that inturn c...

The SP i am calling inturn calls other stored procedures. Can't we use a SP which inturn calls other stored procedure with the odbcstage? If i call a single SP with out any SP in it,it is working fine. The error message is "SQL statement has incorrect number of result columns" Did any one ...

Thanks you, Can i use this in a jobcontrol of a serverjob. I am on win2003, is it possible to use batch jobs to invoke storedprocedures(MS SQL 2000) through jobcontrol. I am trying to run a do some thing stored procedure in the odbc with a dummy column sending to a seqfile. I am able to run the SP's...

Hi lstsaur ,
I am not sure abt the sql server homes. I am new to sql server,Do you have any idea of how they present in the SQL server directory structure.
Thankyou

Hello Every one, I have a similar problem with Stored procedure, I have a Stored procedure that need to be run between jobs. Is it possible to execute the SP with out any inputs or outputs with in the Datastage Sequence. I am using Ds7.5x2 and win2003,SQL server. Please help me in running the sp wit...

Oops!
I am sorry, i was refering to Roy.

Yes Ray, the jobs that are dragged on to the seqence are populated properly.
Myn is win2003, i dont know the fix.

Thanks Roy and Ray.

Ray,
I am able to drag and drop, but strangly i am not able to acces them through jobactivity. I will try on Reindexing. For time beeing "draging and dropping" will move my work ahead!
Thanks Ray

Thanks Roy, They are compiled and are in runnable state. I am able to run them individually, but when i right click on sequence--> jobactivity-->property-->job-->jobname browser button, they are not accesible. And the entire category is blank, it shows nothing.(The category has parllel, server and a...

Hello everone, I have created a sequence with 5 job activity icons. When i try to select a job for the job Activity tab my jobs are not visible or not accesible. (I am able to open them directly in the designer as individual jobs). The catogory that has the jobs shows a '+' sign but when i (click on...

Sure Ray,
As i posted in my earlyer messages, i only changed the datestage datatype to timestamp, left the sql server datatype as datetime and the rest ramain same.
Regard,
Via

Hi,
I finally did forced the data type to timestamp tough it is a datetime in sql, it worked:)
Thanks folks for all your help, i really appreciate your responce.

Via

Hi dsx and vidya, I tryed chaning the ouput data type to datetime , but there is a conflict with the string to datetime datatype. Now i am thinking of pushing this entire date+time as varchar to sqlserver and then write a stored procedure to chage it to datetime! This is some thing that is not sugge...