DSXchange

I have financial values coming in from a source that is 30 decimal places. I need to round these to 20 decimal places. I read some posts on changing the EXACTNUMERIC setting in the uvconfig file. Which I done but it did not work. Here is what I have done so far. Stopped the DS services. Made sure ev...

Currently, with my version of DataDirect (4.2) I cannot read an Excel 2003 file. I have to open the file and save as 95-2002 format. Is there update drivers or another way for me to read this file. We receive the file from an external party and have no control over what they send. I have tried to se...

This was my solution. Old. If IsNull(field(lnk_In.CF_String,";",5)) Then DateGenericToODBC(RunDate) Else DateGenericToODBC(field(lnk_In.CF_String,";",5)) New. If Count(field(lnk_In.CF_String,";",5),"/") = 0 Then DateGenericToODBC(RunDate) Else DateGenericToODB...

There was nothing defined to represent Null on the format tab. I added the <NULL> and still got the same response. This seems to be just pretty weird but anyway I have found another way to do it so thanks for any help.

Since its coming from a flat file. ISNULL() wont work. It doesnt work at times on flat files. Use the Len() function. What Length does it give for empty column? I mean from this row 20000000 ; 0 ; 0 ; 0 ; It gives me a length of 10. Here's my code. Len(Field(Trim(lnk_In.CF_String), ";", 5...

Let me just say that if it's odd I will find it. I have tried using the trim and isnull functions, in practically every way possible but no help. Plus, when I try and get the length from the code below it gives me a length of 10 which is the same length as the date so I can't supply the default date...

This should be fairly easy to accomplish but I have spent way too much time on it so I figured I would ask the experts. Here's my situation I am parsing a cashflow file and am having problems with the last column. Basically what I want to do is pull the last column. If it's null then set it to a par...

Yes, that is exactly what I am saying. If I don't use the read-only it works fine. Yes, I have checked that the job is passing the correct parameters. I'm at a loss but weird things happen to me so it's just par for the course.

I have a weird thing going on here with Version Control and I will try and explain what is going on the best I can. I have a project in Test that I imported into Version Control. When I promote using the read-only feature, when I start to run the jobs I get SQL server login errors or UDB login error...

Solution. I have found why the crazyness was happening. I had a routine that looked up a value in a hash file and if it didn't find it, it would call another routine to get an exception value. The second routine was not opening the hash file or putting it in memory (something like that) until after ...

First, let me start by saying I have read many posts on this website trying to see if what I am trying to do is possible. But since I am relatively new to DS I thought I would ask some more experienced people on their opinions. Here's what I am trying to do: We get data from one of our systems and t...

I have checked out my data. I can write the data to the table through Access or a stored procedure. I have key-entered every field into the table and it worked fine. I have validated that my data is correct. I know people must think I am crazy or un-educated in Ascential as this makes no sense at al...

I know it doesn't make sense that's why I am so confused. Anyway, here are my three errors. This comes from the Dynamic RDBMS stage. load_IMD_Asset_Alloc_Monthly..xfTrans_Monthly_Allocation: [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification Note: The error below stops...

I have tried only one line of data in a file. It fails. If I copy the line down then one fails and one passes. I have created a new file and got the same error.

I have the transform correctly. The row right below is exactly the same minus one field and it works fine. Same with nulls, I have procedures to map some of the null values and let others through.
Russ