DSXchange

I was hoping that was the issue but doesn't seem to be as I used the expression editor to bring in IsValid and I got the following

IsValid(%typestring%,%valuestring%)

I even tried adding the 3rd argument but the text stays red and when I validate it says too many argumnets in expression.

What am I doing wrong. I first did this and it worked fine unless I encountered an invalid date like '999999' StringToDate(stgAcctDate, '%1950yy%mm%dd') So, then I added this to take care of that: if IsValid('Date', stgAcctDate) then StringToDate(stgAcctDate, '%1950yy%mm%dd') else SetNull(). Everyth...

I received the same error when doing a lookup in Parallel. I wrote a small parallel job the read in my lookup file and process it through a Remove Duplicates stage and got the same record count going into the De-Dupe stage as came out. Therefore, duplicates is not the issue. This Warning only starte...

Great Thanks!

Yeah... sorry about that. Anyway it turns out the field on the table was Not Nullable on the table where the other table it was nullable. I don't have the error anymore as the logs cleared. Anyway is there a way in a select statement in the "AS" statement to define a field's SQL type? For ...

I'm getting an error using the IsNull() function on a field that DS is saying is not nullable. However the field is nullable on the table(SQL server) yet datastage, looking at the schema looks like it doesn't see it that way. Below is the SQL. As you can see the field in question comes from a subsel...

Yeah I'm coming from a server background. Parallel has been quite the adventure with things like this so far.

Thanks for the response. I tried those as well. I just did happen to stumble on to the issue. In the 'Extended' column within the transformmer I had to select miroseconds and it worked when writing to the database. When writing to the file I had to select miroseconds as well. In addition on the sequ...

I have a string "2011-01-05 06:10:30,339" that I try to move to a timestamp field but no matter what I try the milliseconds are getting cut off. The timestamp is defined as timestamp len=23 scale=3. inside a transformmer I've tried: StringToTimestamp(field,"%yyyy-%mm-%dd %hh:%nn:%ss,%...

Unfortunately that did not work either. Didn't fail but it put the value of the input field in the output instead of NULL

EVNT_ACTVTY_SEND = make_null(resultcode)

Looks like same error as when I tried SetNull(). doesn't seem to like functions. EVNT_ACTVTY_SEND_TMSTMP = make_null() main_program: Error parsing modify adapter: Error in binding: Expected source field selector or conversion name, got: ")" Expected destination field selector, got: ")...

Any way to set an output field to NULL in the modify stage? I've tried
EVNT_ACTVTY_SEND = null and
EVNT_ACTVTY_SEND = SetNull()

and neither work.

thanks

We currently are on 8.1.0.1 (which is fix pack one) Not sure if there are additional patches to the Db2 connector after this.

So, have either of you used the ODBC connector with better results?

I did output it in a PX job and the character still was the same.

I'm new to the whole NLS thing. Can you chage the NLS setting per job? If so is it common practice?

Has anyone seen more reliablity with the ODBC connector stage compared to the DB2 connector stage? I'm new to parallel and I like the performance of the DB2 connector especially settign it to insert new update existing. However, I been hit or miss with the stage as there were times I'd change just t...