DSXchange

MCN with OCONV extracts only numbers. You can also look at the function DIGITS(). It does the exact same thing. It's exactly what I want. I want to extract only digits from the input string, rejecteting all other character. I saw the online DataStage manuals and now I know the differences between &...

kaps wrote:Use MC/A function with oconv.

I just tried, before reading your answer, the oconv function using "MCN" as second parameter and it works well. Is it the same? Anyway thank you for you help.

I'm looking for a DataStage function that recognize and extract the numeric character from a string. For example I have a variable with this value: "Ab12gh3s4" The function have to returns "1234". I can created a function to do that but before I would know if it already exists a ...

kumar_s wrote:You can also find some DOS based freewares http://www.pc-tools.net/dos/dosutils/, which can help you.

I'll do that. Thank you again

This shouldnt be just due to the DS upgrade. Check whether the table has any lock, and the job might be waiting for the lock to get relased. Why cant you check the disk spcace? What do you mean by central memory? Is it temp dirictory? If so what stops you to check the avaiability of space? I can't ...

Hi we are upgrading DataStage Server from release 7.1 to 7.5.2 one and it works all fine but sometimes the duration of some Jobs is different. For example a Job Server who read data from an Oracle table and write them onto an hashed file in the previous release run in 20 minutes now in...24 hours. I...

If I understand the problem you are modifying a job's parameter from inside the job itself (in the job control). This is not allowed and would explain why your changes aren't "seen" in other parts of ... Yes, you understand my problem. I supposed that it is impossible. I'am not able to re...

Please explain exactly what you did and why you believe it did not work. What is the nature of the "script" in which parameter values are to be found? Do you have code in your job control to read th ... Ok. above all, I'm sorry for my english. I know it is orrible. I have a Job server cal...

Hi a simple question. May I set the Job Server parameters from a script in the relative Job Control? I try to explain the question better. I have a Job Server and I need to set its parameters after having validate them. So I have created a Job batch "A" validating two parameters and execut...

Ok... I know it is possible. My point is that (IMHO) it is the wrong approach - the Folder stage should be used with XML files. Most people would either concatenate the four files together before-job and process them at once, or create an interative process where you loop four time and process each...

I've never tried to use the Folder stage with sequential files other than to get a list of file names, not contents. :? The Folder stage is meant to process XML files and so is typically followed by an XML Input stage which does the parsing into rows and columns. I know that it is possible, and I h...

Hi I am trying to understand how to use the folder stage. I have developed a Job having in input a folder stage, after a trasformer one and finally a sequential stage. It works but I am not able to understand how I can split the rows returned from the folder stage. I'll explain it better. In the fol...

Hi I know this is a stupid question, but.....May I access to an Oracle instance from a bulk stage using the OS authentication?? I want to use the bulk stage to load data onto an Oracle 8i table. The only user I can use is the same that I use for access into my workstation (windows xp pro). When I us...

[quote="stiwari"]Hi Umbix62, Thanx for the reply. Just one quick question How much time it took to load 3.5 billion records and i would be more than thank ful if you can tell me what kind of partition you created and how many jobs you ran in parallel to load the data. Thanks Sumit[/quote I...

kris007 wrote:Yes, you can use ODBC driver access to connect to SQL server and pull
the data.

Kris

Ok, but you know if it is the only way to resolve this problem?