DSXchange

OK, The following works a treat for me: $ cat john.txt 1,a,111|2,b,222|3,c,333|4,d,444| Sequential File / Format tab: Record level Final Delimiter = End Record delimiter = | Field Defaults Delimiter = Comma Quote = None ... With 3 varchar columns defined in my stage. Is that what you're doing? J.

Rajan,

Try specifying the "Record Delimiter" with '|'

J.

Sorry - I've been writing alot of Korn shell script recently and old habits die hard ... Yes, for Windows you'd submit DEL. (Ah, yes ... I remember Windows ... popular in the 90's, wasn't it!?) Arnd - I think that's the second time in as many weeks that you've spotted the deliberate mistake in my po...

koolnitz, Glad it worked for you :-) The difference between Compile and Force Compile is the later forces compilation of the Transformer code (into a '.o' I believe) whereas 'regular' Compile is optimized so it will only compile transformers when they have been altered since the last compilation. HT...

1. That approach for deleting the file on your DS server is fine. 2. To delete the file on the remote machine you can use the Telnet properties in the FTP stage: Telnet Prompt 1 Login Telnet Reply 1 {youraccount} Telnet Prompt 2 Password Telnet Reply 2 {yourpassword} Telnet Prompt 3 $ Telnet Reply 3...

Does your job contain any transformers? If so, have you tried a "Force Compile" to rebuild the transformer code?

J.

incognico, Sorry - I misunderstood the intent of your original post. I thought you wanted to perform the comparison in DataStage. You can't submit the XXXFromDate() functions to Oracle as these are DataStage functions. The Oracle equivalent is: to_char(sysdate,'dd/mm/yyyy') If you want to always com...

Whoops - Sorry ... Still learning to read ...

How about:

MonthDayFromDate(CurrentDate()) : "/" :
MonthFromDate(CurrentDate()) : "/" :
YearFromDate(CurrentDate())

J.

X = OCONV(DATE(), "D/E")
X = "16/10/2006"

I don't believe you can do this using classification tables. It doesn't make sense to 'standardise' multiple tokens into a single classification. A combination of multiple tokens is a pattern, which you are quite rightly processing in your PAT file. It shouldn't be a big deal anyway as you can execu...

Is this what you're looking for ...

viewtopic.php?t=96039

J.

RK, If you need to identify/extract more than just this one type of string then a QualityStage standardisation job would allow you to classify and extract tokens from the string regardless of their input format. In this case, the classification file of your selected ruleset would define identifying ...

GSSaru, Dare I suggest you consult the documentation? Both the Parallel Job Developer Guide and the Online Help Files contain good descriptions of the differences between the three stages. If you're really stuck start with the Parallel Job Developer's Guide section "Join versus Lookup". HT...

Hi Pey, In the repository you should be able to see your imported table under Table Definitions -> Oracle -> {DBName} -> {TableName} If you open that you can modify the definition on the Columns tab, or you can get direct access to the schema version of definition by clicking [Show schema] on the Pa...

Hi Sasi,

This is a good place to start: viewtopic.php?t=89545

HTH,
John.