DSXchange

Do an exact search on 'ascii to ebcdic'. You will find quite a few conversations and recommendations.

Sure there is. Check in Server Job Developer's Guide under Command Line Interface. dsadmin and dssearch are explained after dsjob.

Setting these parameters will overide the default settings. Thats why your job aborted when you set the time interval to 0. Something else is going on. You will see the same behaviour when you set it at the project level as well. What makes you think the data is not getting committed at the commit i...

You did not answer my second question. This routine does not get shipped with the product and hence must be a user defined routine. This routine must be present for it to show up in the drop down. Check your routine repository.

Try AsFloat() or AsDouble() in the px transformer for a parallel job. Type conversions are explicitly required in a parallel job.
For a server job its as easy as changing the target datatype.

This env. variable works along with APT_ORAUPSERT_COMMIT_TIME_INTERVAL. Add that as well and see if it works.

Can you see that custom before/after job subroutine in server jobs? Does the routine exist?

What did you find out when you did a search? vmcburney (from the top ten posters) has a topic about this in his blog. Click on his name, check out his blogs.

You are right Craig. Its just that I have explained this piece in a lot of detail in the past and did not want to go through the complete description again. I should have just searched for the post and provided the link, but I got lazy

Also, specify the decimal as varchar and then take the length. I forgot to mention this when I suggested to go with the Len() function.

My bad. The matches argument is wrong. Please try again with the following.
Try both:


OR

The way I see it, it really depends upon ID1. Do a group by on ID1 and get the max of ID2 and ID3. Is that correct? If yes then pass that sql and create a hashed file that has only the first three keys. This hashed file will now contain all the keys that need to be set to Y. In one job take ID1 from...

Ok tell me this. For a Decimal value 12.33 coming in, how does it show in the database/dataset? Does it show 12.33 or 000000000012.33 for (12,2)?

You can also try with lenth function.
Len(in.Link) = 14 for (12,2) and
Len(in.Link) = 17 for (15,2).

Is the name of your stage variable inColumn.Price ? I doubt it. Say your stage variable is called StgVar, then the constraint for Decimal(12,2) should be

O yea. Sorry guys, my mind was still on the other post where I did provide a reference. Here's the site: m I was even answering this post while my mind was still stuck on the other one. I dont think you have to worry about the 30 day limit if you will be doing it via ODBC stage. I have never tried t...