DSXchange

:idea: sadnemous: not sure why the fascination with the color blue, best to stick with [/b] tags for things you should preserve the formatting of, like your osh code and not worry about what color to make things. :wink: And there's no need to quote the post you are replying to, it's all right there ...

Or add 19000000 to the decimal to get a number in YYYYMMDD format, then DecimalToString() gets you close. After that, do you need a DATE or a STRING in the (external) format shown?

So... the last four digits are MMDD and anything before that can be added to 1900 to get the YYYY is what it looks like to me.

First suggest would be to find out what your example dates translate to so we can get some idea what the conversion might be. Are these real examples of your incoming data?

Longvarchar. BLOB = binary large object, CLOB = character large object.

Yikes. So, what exactly is in your sequential file - each records holds a BLOB and you need to call the procedure 10 times? Or you need to call the procedure once and somehow combine the values from the first 10 lines into the BLOB? Can you clarify that for us, please? I'd also be curious what kind ...

Hmmm... perhaps not. Did you get this figured out or are you still looking for some help with it?

orchadmin dump specifically.

Not sure how I missed this... well past time to get this into your own post.

Not sure there's a "one command" DOS solution. Do you have the MKSToolkit installed with your product? If so you have UNIX-like commands at your disposal and those can certainly be one shot.

suja.somu wrote:Where can I find the full pathname of the sqlcmd

A search from Windows Explorer should turn it up.

Google. Seriously, DOS commands and 'tricks' are well documented out there in the wild and it shouldn't be hard to find multiple discussions on how to (for example) count file records in a DOS batch. Or check a file's size. Or whatever you need. That's what I would have done in your shoes.

Because all of your answers are contained within them?

Well, heck, of course - the z modifier! Why didn't I think of that?

Why don't you show us what you tried, post the code? The DOS command DIR will show file sizes but you'd need some batch skills to create a useful check which is why Ray suggested the DataStage BASIC System() function.