DSXchange

Hi I have the input date format to oracle enterprise stage in the format 12/09/1991 10:48:00 ,and the metadata of the date column in target table is timestamp (6) . When I do an upsert its loading the table ,but whe I change the option to load instead of upsert I am getting the error Oracle_Enterpri...

Hi, Look in the stpstage.pdf (in the install CD if your Docs library doesn't have it) to see if your version supports sybase using the stp stage. (7.5.1 Docs say Sybase is supported So go over the pdf and see if you missed anything) What exactly do you need to do? I was able to get a SP result set ...

You an use Looping activity in Job Sequence to have a loop for 10 times and pass the value of n to the job 1-10. So that you can retrive nth row for each iteration. Pass on this value either as UserStatus or write into an external file and read it and pass it as command output through Execute comma...

I have found several posts on the topic but as I am new to datastage probably I dont find them quite useful I have a sequential file with 2 columns and 10 rows I wish to call a job one time for each row and pass the columns/values as parameters to that job. If possible please include a breif detail ...

Hi Abdul, Yes you can use UtilityJobRun transform function for parallel job too orelse as suggested by DSGURU2B you can pass these values through the unix script. Thanks Sam I dont see the UtilityJobRun transform function in the transformer stage ,it is in user variable activity stage ,but dont kno...

Job5 is not able to pickup the parameters because it is not in the format that it requires. It should be pipe delimited. Gateleys provided you with the correct format. Notice that you must create and string to define all your parameter as : " Paremeter = value | parameter2 = value | paramenter...

chulett wrote:You'll get one number - the total number inserted and/or updated - but not the two distinct numbers the OP wants.

Using a shell script can't we do it twice once for inserted and other for updated ,if there are two nodes you can add the numbers
Thanks
Arif

If you really want the insert/update logic to be handled by the database, all you need to do is do a lookup on the target, that will give you the inserts, subtract that from the total, that will give you updates. Just a thought ,if you can access the director log ,using dsjob -logdetail command fro...

I am calling a sybase stored procedure from the transform STP stage , It has an seq file as input ,and I am using transform STP stage,but the stage is not generating a procedure call using parametrs and column mapping. like Oracle stored procedure generates BEGIN procname(:1,:2) END Does some body k...

Hi
Is it possible to call the syabse stored procedure using a transform STP stage.
I am not able to generate the procedure call syntax ,and getting error
Procedure expecting input parameters .

Hi
When I run the job I am getting the following error
Contents of phantom output file =>
4801 Segmentation Fault
I am not using any sequential files,I am just extracting the data from ODB C looking up against target and Upserting it in target.
Does somebody knows about this error
Thanks
Arif

Thats the same thing I tried
Does something need to be changed here before the equation and can this be used in modify stage
Date4:Timestamp=StringToTimestamp(Date1)
Thanks
Arif

I am trying to use it in modify stage.
Date4:Timestamp=StringToTimestamp(Date1)
The error is
main_program: Error parsing modify adapter: Error in binding: Unknown conversion: StringToTimestamp
Expected destination field selector, got: ")"; input:
Date4:Timestamp=StringToTimestamp(Date1)

Hi
I have arequirement to convert MMM DD YYYY HH:MM:SS AM orPM
to mm/dd/yyyy HH:MM:SS
I cant use a basic transformer for ICONV and OCONV
I am trying to use string to timestamp fn but its not working out.
Any suggestions
Thanks

[Hi
Can you tell something more about the ETL stats,how can I access them from command prompt to extract the no of inserted and updated rows and write to a unix file