Search found 265 matches
- Fri Sep 06, 2013 9:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error converting string to date
- Replies: 3
- Views: 3263
- Thu Sep 05, 2013 2:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error converting string to date
- Replies: 3
- Views: 3263
Error converting string to date
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...
- Mon Oct 01, 2012 2:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unexpect Socket closed error while connecting to MYSQL
- Replies: 2
- Views: 2637
Unexpect Socket closed error while connecting to MYSQL
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...
- Tue Aug 28, 2012 8:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error While reading TinyInt field from MYSQL database
- Replies: 11
- Views: 12569
- Tue Aug 28, 2012 8:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error While reading TinyInt field from MYSQL database
- Replies: 11
- Views: 12569
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 ...
- Tue Aug 28, 2012 7:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error While reading TinyInt field from MYSQL database
- Replies: 11
- Views: 12569
- Mon Aug 27, 2012 11:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error While reading TinyInt field from MYSQL database
- Replies: 11
- Views: 12569
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...
- Mon Aug 27, 2012 9:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error While reading TinyInt field from MYSQL database
- Replies: 11
- Views: 12569
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...
- Mon Aug 27, 2012 8:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error While reading TinyInt field from MYSQL database
- Replies: 11
- Views: 12569
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 ...
- Fri Aug 24, 2012 2:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error While reading TinyInt field from MYSQL database
- Replies: 11
- Views: 12569
Error While reading TinyInt field from MYSQL database
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...
- Wed Jun 02, 2010 8:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error reading sequentail file
- Replies: 4
- Views: 9583
- Tue Jun 01, 2010 8:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error reading sequentail file
- Replies: 4
- Views: 9583
Error reading sequentail file
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 ...
- Wed Apr 28, 2010 1:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sorting in Database Vs Datastage
- Replies: 11
- Views: 7336
- Wed Apr 28, 2010 1:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sorting in Database Vs Datastage
- Replies: 11
- Views: 7336
Sorting in Database Vs Datastage
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...
- Tue Feb 16, 2010 2:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Creating more records based on the day count
- Replies: 3
- Views: 2370
Creating more records based on the day count
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...