DSXchange

I have a simple job which is as follows- 1. ODBC source reads from SQL Server. 2. Necessary logic perfomed in the Transformer which also gets a reference input via a Hash file. 3. Result passed to a sequential file. ODBC ==> Transformer ==> Seq File ^ || Hash File The resulting Seq File has over 100...

Mahesh, I know what you mean. But what if the restartability option is not checked, and my previous jobs have commited the transactions before a subsequent failure in the sequence. Will the sequence "re-write" the transactions (even though they might have commited)? What if all the constra...

Hi, I am using DS7.1 with Oracle9i. I have a job sequence that is running for a very long time. I realized that there was a query problem in one of the activities. So, I stopped the sequence, rectified the query. My first question is- If I run the job sequence again, will it start all over again fro...

Hey Neeraj, An easy solution would be to ask your DBA to store the procedure in the proper schema in Oracle. Use ODBC stage, import the metadata for the stored procedure in the ouput tab. This stage will the make a call to the procedure which is executed by Oracle. However, I am uncertain about the ...

Well, you can't do that. The SQL is bound, it's not a place to write a script. If you need to execute a delete statement, then do it either as before-SQL or using a command execution of OSQL. Can you please help me with this? How should I proceed and what/where should I put the delete statement? Wh...

Where did your SQL statement originate? Is is generated or user-defined? Something looks fishy with your SQL. Its user defined and queries SQL Server. The SQL is- DELETE myTable WHERE hiredate < some_date; INSERT INTO myTable("ID","Name",""hiredate") VALUES (?,?,?)

WHen I try to read from one table, then delete rows in target(another table in another db--but both SQL server) based on some condition and then insert the rows (parameters have been assigned for both databases) via a transformer, I get the following error. Transformer_2.DSLink4: DSD.BCIPut call to ...

I am reading from a Seq File into an Aggregator. I am using pipe as a delimiter and " is the quote. The source is SQL server. I have tried all the functions, viz. Convert, Ereplace and Trim. But the problem persists. I keep getting this error- SeqFile1.DSLink4: read_delimited() - invalid quotes...

Prefer IsNull() to "= Char(128)". It is more efficient and more reliable. The Rnd() function generates a random number. You need the Fix() or Oconv() function to do rounding. Hi Ray, I tried Fix() to round the number as below, but it still doesn't round it. Below is the code which takes i...

ketfos wrote:Hi,
You are trying to calculate the diff between to date fields.
fromX.fire_date, fromX.hire_date)/7

Both teh fields are same.

Ketfos

If only you would "see" properly..they are 2 different dates- hire and fire.
May be you had an illusion.

I have a stage variable sv_weeks which performs a DateDifference. I had to check NULL condition for fire_date, if it is NULL set to 27, else set it to difference between the 2 dates of type Timestamp (23,3). sv_weeks = If fromX.fire_date = char(128) then 27 else DateYearFirstDiff(fromX.fire_date, fr...

1. What does RowProcCompareWithPreviousValue return after the comparison? Is it 1 if True and 0 when false? 2. Can I use IF(NOT(sv_ID)) to check for false condition( sv_ID is my stage variable which uses RowProcCompareWithPreviousValue to compare my current ID with previous ID)? Or will it be IF(sv_...

WHAATTT!! Can't I invoke a stored procedure written in SQL Server from DataStage?? I have an ODBC stage which should be made use of to invoke the SP. If it is not possible, please tell me how I can get around this. And, I don't seem to have a Stored Proc Stage in my version of DataStage (7.1r1). If ...

That's because you appended rows with X+1 columns in them onto the end of rows with only X columns. If you want to keep the old rows in the file and still be able to read them in, in the reader stage scroll the Columns tab over to the right and change the value of Incomplete Columns. It defaults to...

My job is as follows- ODBC--->SeqFile----->AGG.....etc The ODBC has a user defined SQL. SeqFile is used to append current records to previous ones (so, it has been set to append rows). The job runs fine. Now, I need to add one field 'xcount' to ODBC (which undergoes a SUM in the user-defined SQL). T...