DSXchange

Alternate soln. Take the value as character(having Varchar(10)) through-out all the stages of the job(even in the OCI stage, have it as varchar) and in the SQL query, use date function with format matching with the input pattern. ex: Col1=varchar(10)=12/01/2002 seq-->Xfm-->OCI(table name: T1) Write ...

Just a feeling, are you sure that you are getting two types of delimeter?
Coz, I have a feeling that it could be Quote Character as double quotes and pipe as delimeter.

Ram, You can just have one output link, without any input link. Trick: 1. Column value should be hardcoded, or derived the way its done my example in this post. 2. Have at least one stage variable in the job(may or may not have any purpose, but required for successful compilation of job). 3. limit t...

You should have at least one either start point or end point. :) Its very simple needs only good logical thinking, as its all about playing with Iconv , Oconv and some other simple functions. Say you want calender, something like 2yrs, 3months and 5 days from a given day. JobParameter: svMyDate=01-0...

Sorry for not submitting my last thread in proper format. Below potion was answer to "Prashantoncyber " question :) "Through Oracle front-end Tool(Quest Central or Toad) you can trace session and see which user ? , what query is running ? and how many resources are consumed for runnin...

Its one time thing or daily based ? You want it to be dynamic ? One of the way , when you have the start date and end date. Well your design should be as(Its same as Ray suggested) Transformer ------> SeqFile JobParameter: svMyDate=01-01-2005 svMyEndDate=01-01-2010 Stagevariables: StageVar =StageVar...

Through Oracle front-end Tool(Quest Central or Toad) you can trace session and see which user ? , what query is running ? and how many resources are consumed for running a query?. Well I had tested it in my case it was killed. But wanted to know from people out here on forum, if they came across suc...

If a huge SQL query is submitted in the ODBC stage and the job is reset/stopped, is the query killed or does it keep running on the DB. If yes, what is the solution? Recompile the job?

hi, Is there any keyword in odbc stage used for reading [b]text file [/b]equivalent to rownum of oracle. This was my first post. :) in sqlldr SKIP, it does not read the complete record, "there is NO movement of records in cache", , it just check for the presence of record and move to the ...

I think you'll have to go with a constraint testing @INROWNUM vs a parameter you passed in at the start of the run. I don't think you can do a select where rownum > something. ya i know, i can use @inrownum. but using @inrownum would mean that i would be reading all 8million records, but not taking...

Through datastage, i dont think there is anything better than the logic you are already using.

to get only numeric value from a string : oconv(string,"MCN") to get only alphabetic value: oconv(string,"MCA") to get numeric+special character value from a string : oconv(string,"MC/A") to get only alphabetic+special character value: oconv(string,"MC/N") You...

Just doing R&D. taking a case where i have 10 million records and i am loading into a target(could be Database or file). Say after 8 million records my load fails due to space constraint in my target server. Now instead of starting the load from begining, i would prefer to start 8million+1. so w...

hi,

Is there any keyword in odbc stage used for reading text file equivalent to rownum of oracle.

Prabhu, whenever you have question on any in-built Routines or Transforms , like; what operation a particular routine is doing? what should be the input or input format? what would be the output or output format? etc.. etc.. Just go to DataStage Manager and open that routine, you will find detailed ...