DSXchange

Thanks for sharing your find. Thats how it should be with all of us.

Like for example, what specific API are you looking to execute. If it can be executed from command line, i believe it can be executed within DataStage. Need more info for a specific answer.

Welcome Aboard
Use the search facility of the site. Its very powerful and can/will save you time. Do an exact search on the key words 'must match field's fixed width'. You will see that this has been discussed in the past, time and again.
Regards,

Like duh. I think i am pretty muddy today. Need more caffene

Ok, well, it was an interesting find by Ray, uptil now that is.

Good find. Cases like these need to be stored in a seperate forum maybe, so that issues can these can turn up during search. Maybe a site enhancement.

Either way, now he has both the answers. Can work/play with both the options

Welcome Aboard
By specifying (') in the quote character box in seqential file stage properties.

I don't believe in that other thread that anyone actually confirmed the DDL v. DML assertation for the DELETE. All we really know is the TRUNCATE command 'worked by adding a semi-colon'. No one made that assertion, True, but Delete being a DML command and Truncate being a DDL command, points toward...

What does your complete date look like?

Is your target a Date field or Timestamp field ?
If date the do this

This will convert your outpu to YYYY-MM-DD which oracle accepts.

You dont need the second Convert. This will work


Great thinking trobinson

According to what i learnt recently, is that a semicolon is not needed for a DML (delete) where as its needed for a DLL(TRUNCATE) command. But your observations are making me question my knowledge. So when you ran both the DELETE and TRUNCATE commands, without the semicolon, they are actually deleti...

For a single character use the Index function in a stage variable to do the check. Something like if index ("ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefhijklmnopqrstuvwxyz -'",in.Col,1) > 0 then @TRUE else @FALSE If its a string then you will have to write your own function to do that. Functi...

I think we need more expert advice. Lets wait for the true Gurus to give us their expert advice. If nothing else works, make a copy of the sdk routine, name it myDataTypePicS9(). This way you will be able to compile it and run it. Make sure it works in the test box. Export the new job and your user ...