DSXchange

It should populate 5439 cc. But if it is not possible to do without the "hyphen" then I would use TRIM function to do it.

vick

Sorry about that. Yes the rule you defined is correct.

I want to populate "? L" or "? cc" (?=numeric say 3.5 L or 5.0 L or 5390 cc) I want to populate "Null" if "L" or "cc" is not found.

TIA

Folks, I m trying to use the Modify_Stage and I was wondering if anybody has used "lookup_int16_from_string" Conversion. I m trying to pull the substring from the column 1. "3.5 L V6 24-Valve DOHC" ---------------------> 3.5 L 2. "3.8 Liter V-6 24-Valve DOHC" ----------...

Thanks a lot for your responses. I will mark the issue as resolved

yaa hoo


vick

Hello I am using an Oracle_Enterprise_Stage as my source, a TFR stage and Sequential_File as my target. I am trying to use the SYSTEM VARIABLE - @NULL for a VARCHAR datatype column in a transformer. These columns are Nullable but I get an error (if I insert @NULL it complains as syntax error - red c...

thanks DSguru2B.

The code you posted, I have copied it to a file with a .c extension. How do you compile in UNIX (AIX).

I apologise if I m sounding silly.

TIA

Hi I have a query on C-routines in DSEE. I have a C-routine that performs "matchfield" functionality of BASIC Tfr. Am I right in understanding that the C-routine needs to be compiled in the unix box and called to perform the functionality? I have "General" "Creator" &qu...

Thanks a bunch DSguru2B. Appreciate all your help. I will try and let know.

Thanks once again

V

Hello folks

I was wondering if there is C-routine sample that somebody could pass across. I searched for it but could'nt find what I need.

It would be of great help to me as I will learn to code in a new language.

TIA

vick

Thanks DSguru2B!

I figured that.

All you need to do is double click the column and on the "Edit Column Metadata" dialog box select the nullable tab. Under that select the nullable field value and enter ' '.


Appreciate your response.

HTH

Hello, I m doing a straight map from a table to flat file. The table has 127 rows but only 100 rows gets through. Oracle_Enterprise_stage ---------->Seq_File_Stage. The log on the DS Director indicates this [b]"Field "Col_2" is null but no null export handling is defined"[/b] I c...

Hey folks

My team lead has decided not to go with BASIC Tfr as he needs this to be a pristine DS-EE environment.

Looks like I need to develop a C-routine for this purpose.

Any suggestions, samples, pointers on developing a C-routine.

TIA

Thanks! The no of records is 6056 but although the canvas on DS Designer shows 6056 if I do a wc -l <filename> it returns only 5104 records. It does not pull @null rows. I have played around with the BASIC TFR stage with 6 different logics including a routine but I m not able to figure out the reaso...

Thanks a ton Ray! I plugged in your code and concatenated with "V-" and it works great except for 5 & 6. (Values after ----------------> are the results) [code] 1. "3.5 L V6 24-Valve DOHC" ---------------------> V-6 2. "3.8 L V-6 24-Valve DOHC" ---------------------...

Thanks Ray for your inputs.

I want to handle them in a "single" format "V-numeric".

The string may have different format for for different records but I want to pull only the part with "V" and the numeric and format it later to "V-?".

TIA

V