DSXchange

I am told that because of the limitations of the varchar field in sybase 12.5 the original sql developer was filling the field as follows: sqlfield=sqlfield+"filling the varchar field with 255 chr chunks at a time" he says that even though you can define a varchar over 255 chrs you can onl...

I have done that but i get the 2nd error message. It's odd because i can view the data as varchar(1024) but then in the transform or straight to the export stage it chokes on the field length being greater than 254. when i import it as a longvarchar(1024) then it all works up to the export where i g...

Hi all, I have to read a SQL server 2000 table which has a varchar field 1024 bytes long and i need to write it to a sybase table which has the same varchar field length (and is in production so i cannot change the field type). what i'm getting is the error "Sybase Server message 5702 (severity...

ok this is resolved, turned out to not be a datastage issue. the dba's rebooted our iq server and forgot to path/mount the folder, so iq could not see the dat file the sql file was referencing.

thanks everyone for all your help in this.

Jim

ok, i had our Unix guy check the permissions and he says they are correct so just to rule it out i rebooted the server but am still getting the same error.

I'm also noticing that more of my existing jobs are starting to fail for the same reason.

huh...

ok,

Hi all, I have a very simple parallel job thats pulling 18 records from SQL Server and putting them in a table on another server/database (IQ 12.7). This is something i've done 100's of times up to this point without any problems but for this job i'm getting an "ASA Error -1006133: File does no...

I'm not familiar with a sparse lookup?

Is there any other stage or methodology i could try to use?

Right.. that seems to be my problem with the lookup, it cant perform a lookup on 2 overlapping date ranges..

thanks, i will try the transformer constraint... though on the lookup stage range lookup it only allows me to do a lookup 1 date field not on both field.

parent.eff_dt<=child.term_dt AND parent.eff_dt>=child.eff_dt

i would like to do this in the lookup stage if possible just dont see how.

Hi all, I am trying to get a key field from a reference table based on a date range overlapping another date range in the reference table. main table: rec # field_id eff_dt term_dt 1 1001 2003-01-01 2007-12-31 reference table: rec # field_id eff_dt term_dt 1 1001 2001-01-01 2002-12-31 2 1001 2004-01...

for some reason i thought they were only used for input files.. i just tried it and it worked perfectly, thanks again!

thanks, didnt know that!

thanks, didnt know that!