DSXchange

I tried too. It doesn't work. I would call this a bug as it lets you select the target decimal length by selecting the subtype "Decimal output". However, when you change this (at least in my case) the job completes successfully and nothing gets loaded. Always nice. I was able to get to wor...

Just got patched that fixed. Ecase 91460.

Tx.

DJM's solution he provided earilier is much faster. I find it more difficult to read, but it runs in .5 seconds. I think he was being modest by saying 3 lines because his solution will fit on one line very nicely. DJM's solution modified by Ryan. awk 'BEGIN {FS=";"; OFS=";";} { g...

Scale is empty. I have tried to specify a scale, but Ascential blanks out a 0. I tried to import and get same thing. I have placed a call with Ascential and they thought it was pretty serious. They give me a P1 case.

Thanks for your help,
Ryan

I will say that this 3 liner below is much easier to read, but is much slower. It takes 1.5 seconds for a 70000 record test I ran vs. the longer version which takes only 1 second. The mulitple delimeters have my head spinning. ## Author Ryan T. Putnam awk 'BEGIN {FS=";"; OFS=";";...

Using ODBC Enterprise Stage if I use the metadata that was imported, Ascential corrupts my decimal values that do not have any precision. That is, I have decimal(18, 0) columns and Ascential corrupts the values and sets them to 2147483647 or -2147483648. If I change the datatype in Ascential to Deci...

I don't know how to do this with pivot stage. However, you could: Use a sequential file stage with a delimeter that does not occur in the file. Maybe \xF8 Also, set Quote to none. Store this in one column. Example col1 varchar without any length. Send col1 down a link to an external filter. Run this...

Thanks. For the most part that worked. I copied dsjob and got an error that libvmdsapi.so could not be found. So, I copied that too and updated my libpath to the desitination path. It worked after that. Just needed to specify -server <server> -user <user> -password <password> properties for the comm...

I would like to bundle dsjob and other files needed so that dsjob can be run from other unix boxes for some event driven actions at warehouses such as end of day/books close. I am curious if this can be done, how it can be done, and any known issues with this approach. Or, if there is a better appro...

You could add a column with the datatype "timestamp/ROWVERSION" (I believe will work in both MSSQL and Sybase). This system column type stores the database timestamp automatically for you when an insert or an update is done to the table. If you keep track of this varbinary you can use it d...

Could anyone comment on the size limitaions of using datasets. Any recommendations on the design of the Lookups. Just one gotcha that I know about. In version 7.0.1 (I believe) of datastage, Ascential changed the way that they allocate space for varchar columns. Datastage will allocate the full spa...

Unfortunately is does not support extended regular expressions. If it did, the following could have been used to get the not.

source_cd LIKE '!(abc).*'

However, since NOT takes a boolean, you can use
NOT(source_cd LIKE 'abc.*')

Thanks,
Ryan

This is a regular expression. When using * you the preceding element is used to specify what to apply the * to. In a regular expression a * means zero or more of something. And, a . (period) indicates any character. Thus, I would expect that 'abc.*' would work. This should/would mean the string that...

I wonder what the current application/job designs look like and if there is way to change what you have to increase the performance of the jobs? Here are my ideas. - If you are going to group by A and A,B and A,B,C you could create a dataset that is sorted and partitioned on A,B,C to perform all thr...

Ray explained how it functions very well. I typed a tidbit of code you could model your script after to read a record coming in into arguments. It is just a model to help you out. At a minimum, you will need to modify it with correct number arguments, the correct internal field separator, and the co...