DSXchange

I actually wanted to know as to what this OConv function does.. Simple enough and the same advice applies. As noted, both the OConv and Date functions are documented so are something easily looked up. And any time you've got something like that you need to check, build a small routine in the Manage...

Trims 'A' for all " " (spaces) from the string created by OConv. Test your derivation in the Manager with and without the Trim() to see.

The files Arnd is talking about are the ODBC config files. You should have a .odbc.ini file in the $DSEngine directory which has all of your entries defined in it. It's where you would have copied the block of text for your [DriverOfChoice] and created a specific entry for each connection. What you ...

Unless the target field is actually some form of a TIMESTAMP rather than a DATE field, which seemed to have been implied in the original post.

Source size? Target size? It is telling you that your source is 'bigger' than your target and so may lose data in the conversion.

No way that I'm aware of. It needs to be 'hosted' somewhere and then you can link to it using the 'Image' tag. Plenty of places for that, however, and most will generate the tag for you automagically.

Thanks John. :D

1. Wasn't aware of that, never having needed the services of the CFF stage as of yet. Guess all the discussions I think I've read where it is used as a target have been over in the PX world, eh?

Those sdk routines convert fields from those types, not to them. If you're unwilling to use the CFF stage, you'll need to build your own version of those routines that 'go the other way'.

Are you not familiar with using sqlplus from the command line? Part of what you pass in is the 'connection' information, user/password@instance specifically. If all this is new to you, have a chat with your DBA or someone in your group who does know this stuff so they can work directly with you on t...

You're right - it doesn't matter at all. You'll not see 'Ans' anywhere other than greyed out at the bottom of the Routine editor. Your 'something more descriptive' will come into play when you actually make use of the routine - either in a derivation when you assign the answer to an output field or ...

Hmmm... actually, I was thinking of some conversations I'd recently had on the subject of TEXT fields in Sybase, not SQL Server. Since I know Jack about the latter, I'll bow out and let others help.

epall, you've marked the Job Type as TX in your post. If indeed this is a TX question, I'd suggest you post in the actual TX forum where those experts hang out.

You mean somehow find and 'read' the email in question, download the attachment and then do something with it? Or is just the act of detaching it to a specific directory enough? Regardless, this isn't an 'ETL task' and the answer is no. Now, if you can script or code something like that, DataStage c...

Cool, hadn't stumbled over that particular function before this. And no wonder, it's nowhere to be found in the online help. I guess it's time for you to once again advise that I read and commit to memory the entire DataStage BASIC Guide.