DSXchange

Hi tiozzo

I m not sure if this is what your looking for but from what I understood
you could try using this in a transformer

[code]

trim(trim(trim(DSLink.col), char(10), 'A'))

[/code][/code]

Thanks much. Here's how the data looks. The string has different formats namely 1. "5.5 L T-spark 24-Valve" 2. "24-Valve Al V-8" 3. "3.5 L V6 24-Valve" 4. "24-Valve Al V12" 5. "5.5 L Twin-Spark" I want to populate "V-?" (V-numeric say V-6 o...

Yes your right DSguru2B! The data looks something like this [code] ColA 5.0 L TSpark 24 V-8 3.0 L TSpark 24 V-12 3.2 L V-14 TSpark 24 1.8 L V-6 TSpark 24 5.0 L TSpark 24 V8 2.0 L TSpark 24 V6 [/code] I want to grab "V-8", "V-12", "V6" so on and so forth Appreciate your ...

Thanks Craig!

Actually the "V-%" is in different position in different records but majority of them are the last 3 characters.

vick

Hello people, I have designed a job that has [code] Oracle_Enterprise_stage -----> Tfr ------> Sequential_File_stage [/code] I have 20 columns in the source and same number of columns in the target. I have to poulate a part of the string, from one of the columns say [b]"A"[/b] into another...

Kashif007,

From what you mentioned I belive you could use the constraints in the TFR to drop the values.

or an If-Then-Else logic

The information you have provided allows me only to speculate -- too less.

Thanks Ray!

DBA is out on a training program and I only hope he is not paranoid.

Durga Prasad, I had a similar error message and this is what I did. Logged on to Director - Job menu - Cleanup Resources. On Cleanup Resouces Dialog box click "Show All" under "Process" and "Locks". Select the PID# of the job and click "Logout". Click "Re...

Thanks for the response!

I was wondering if I could create the table in Oracle (sqlplus) using the same uid and pwd why is this getting knocked out by Datastage Oracle stage.

I assume that the previleges mentioned by you needs to be set by DBA.

thanks

Hi Folks I have an input sequential file stage with 5 records that I 'm trying to write to an Oracle 9g database (Oracle Enterprise Stage). I get the following error. [code] Oracle_Enterprise_5: Access to sys.dba_data_files is required but is not available; please see your database administrator for...

Folks you mite want to include the Xpath (also known as the Description field) on the XML_Output_Stage Input/Columns tab.. HTH [quote]vij wrote: Hi all I am using the xml ouput stage in which i am writing the output to a file by specifying its path.but the file is not created in the specified path.....

Nope Craig. It does'nt. I tried CompactWhiteSpace and TrimLeadingTrailing functions but the result is same. <CR> comes into picture coz of the XML input file derivation and needs to be eliminated. Just thinking aloud if there's something else that could be used other than TFR. Any pointers. Thanks a...

Nope. This was not created from a windows system. A $ shows up @ the end and ^I @ the start. I used the Convert fucntion [Convert (DSLink.artist, CHAR (13), "")but it removes the 1st line frm the record. Original Output Record Bee Gees |COLUMBIA|10|1985|USA| After the use of Convert Functi...

Craig You got it. <CR> it is. But not able to fig out a eliminate the <CR> The derivation of the source xml file <artist>Bee Gees <company>COLUMBIA</company> <price>10</price> <year>1985</year> </artist> <country>USA</country> If I modify the derivation it works perfect. But I expect to get the file...

Hello I have job design with Seq File stage (4 Columns) that reads an xml file and passes it to XML Inout stage. [b]Source XML File: - <artist> Bee Gees <company>COLUMBIA</company> <price>10</price> <year>1985</year> </artist> <country>USA</country> [/b] The target is Seq file stage with "|&quo...