DSXchange

Sorry i misread your response, so are you suggesting that i instead convert the blanks nulls and 0000000s to 999999999 and then do a isvalid to test?

Hi All, I am aware that this issue has been discussed before , but since i am facing the issue even after handling blank or null values. I am reading a file that has been sent to us from the source system and i am reading the date fields as character of length 8. in the transformer before loading in...

Hi All, We are facing the issue of Socket Closed error when trying to read data from the MYSQL database. The very first time in production the process completede without any issues but from the second day onwards we are seeing that two out of 3 jobs that we use to read data from the MYSQL tables. Bu...

I wanted to add this information that the other tables where i am able to read the timestamp fields are of datatype Datetime in the mysql databse , unlike this one filed 'crdate' which is of datatype TIMESTAMP in mysql database.
Is there an issue reading the timestamp field from the mysql database?

Thanks Arnald, I just removed that crdate field and ran the query i was able to read the data both in Heidi tool (mysql access tool) and datastage. Although there were few warnings for the tinyint fields in datastage which said possible truncation due to conversion from int64 to int32. I have given ...

I ran the same query in Heidi tool(tool to access mysql database). below is the error i recieve

SQL Error (2027): Malformed packet

The 4th field is a datetime in the mysql database and in the datastage i have given it a Timestamp(6)

I did try to view the data after changing the sql to SELECT skillsId, EMPLID,cast(position AS signed) as position,crdate,cast(years_exp AS signed ) as years_exp FROM abc It still gave an error but this time a different error as below ##I IIS-DSEE-TFPM-00324 13:30:37(000) <_Head,0> Calling runLocally...

I tried doing the below accordingly SELECT skillsId, EMPLID,cast(position AS int) as position,crdate,cast(years_exp AS int) as years_exp FROM abc and i am getting the below error when i just try to vie the data ##I IIS-DSEE-TDOD-00080 11:55:34(000) <MYSQL_SKILLS_USERDATA> Process meta data not avail...

Thanks for looking this. I did try running th4e job to just read the Tinyint field and it failed with the same error as i had obtained earlier when i try to run the job with all the fields including the Tinyint field The error is as below Info: MYSQL_SKILLS_USERDATA: Process meta data not available ...

Hi All, I am facing an issue while i try to read data from MYSQL table through ODBC Enterprise stage. The error that pops up when i just try to read the data through View data is as below ##I IIS-DSEE-TDOD-00080 16:41:16(000) <MYSQL_PREFFERED_SKILLS> Process meta data not available in database Bus E...

The datatype for the first column is SmallInt and the field delimiter for the file is |~

Hi All, I have this error reading a sequential file due to which 4 records are being rejected due to following errors. Input buffer over run and import error and no default value i did output the error to a peek stage and also did a search on both the errors and did learn that for input buffer over ...

Thanks Craig..
Just one more clarification,
the sort i do on the database will still be good in the process irrespective of the database being on 8 node and the datastage on 4 node?

Thanks in advance

Hi All, I need to have a small clarification, i have this job where in there are several join stages ( about 7 join stages) the first join stage has like 7 input links while the remianing join stages just have 2 input links. We are running all the jobs on 4 nodes. Since there are soo many join stage...

Hi All, I have this requirement where in i am suppose to create more records than i recieve from the input file. I have the file which has the ID , StartDT, EndDT , Location here is a sample data of the file 100 01202010 01302010 XYZ 200 12122009 12312009 ABC 300 02012010 01282010 SGF Now what i wou...