Sybase Stage error
Moderators: chulett, rschirm, roy
Sybase Stage error
Hi All,
I am using Sybase database table as my Source table and i have a user defined query in my source sybase stage.
When i fire the query to dabase i am getting like 20,000 records .but in my datastage i am getting 10000 records.
Can any one have any idea on this.
the query which i fire on my database is as same as which is my userdefined sql qry in my source sybase stage.
Help will be appreciated.
I am using Sybase database table as my Source table and i have a user defined query in my source sybase stage.
When i fire the query to dabase i am getting like 20,000 records .but in my datastage i am getting 10000 records.
Can any one have any idea on this.
the query which i fire on my database is as same as which is my userdefined sql qry in my source sybase stage.
Help will be appreciated.
Thanx&Regards
scorpion
scorpion
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No Ray,
when i tried to see the process of records by clicking'show performance statstics' it is displaying records as 10000.
and i am getting in my target file also as 10000 records only.
my job is like:
sybasestage----->transformer---->dataset
sybase stage transferring only 10000records instead of 20000records.
when i tried to see the process of records by clicking'show performance statstics' it is displaying records as 10000.
and i am getting in my target file also as 10000 records only.
my job is like:
sybasestage----->transformer---->dataset
sybase stage transferring only 10000records instead of 20000records.
Thanx&Regards
scorpion
scorpion
Hi,
I am still facing same issue...?
SELECT * FROM xxx
WHERE LST_UPDT_DTTM<= "#To_Date_Parm#" AND LST_UPDT_DTTM>"#From_Date_Parm#"
and the values of To_Date and From_Date parameters i am passing same values which are in my parameterfile when i run qry in database.
when i run database it is giving correct records,but in datastage job it is not giving correct records.
I am still facing same issue...?
SELECT * FROM xxx
WHERE LST_UPDT_DTTM<= "#To_Date_Parm#" AND LST_UPDT_DTTM>"#From_Date_Parm#"
and the values of To_Date and From_Date parameters i am passing same values which are in my parameterfile when i run qry in database.
when i run database it is giving correct records,but in datastage job it is not giving correct records.
Thanx&Regards
scorpion
scorpion
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
Are they any warning/error messages in the log? Also have you checked your imported metadata, it sometime gives wierd results due to metadata mismatch. As Arnd suggested add two or three records to the current table and check.
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
Thomas Alva Edison(1847-1931)
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
The result you get after adding records is important in diagnosing your error - 'same' doesn't help at all. Do you have just 10,000 records now (implying a limit is set somewhere), 10,001 (implying an even splitting of data) or 10,002 (implying a selection issue)?scorpion wrote:...and As Arnd suggested added some records to the current table and the issue is remaining same...
Hi All,
I got the solution for this issue,actually one of my column in my sybase table is having datatype as 'float-8',but i am extracting this column as 'decimal',this was giving the issue,
when i tried extracting the column with datatype as 'double' ,it is extracting all the records now.
I dont understand why decimal is dropping the records?
any way i got the solution now,and thanks for all.and time to make it as resolved...
I got the solution for this issue,actually one of my column in my sybase table is having datatype as 'float-8',but i am extracting this column as 'decimal',this was giving the issue,
when i tried extracting the column with datatype as 'double' ,it is extracting all the records now.
I dont understand why decimal is dropping the records?
any way i got the solution now,and thanks for all.and time to make it as resolved...
Thanx&Regards
scorpion
scorpion
-
- Participant
- Posts: 247
- Joined: Mon Jan 22, 2007 11:33 pm
check the range of decimal in datastage and float in sybase
If the decimal range is half the range of the float then there is a possiblity of wrap in the numbers to a negative value which would be passed as input to SQL querry.The ultimate result is that the point untill it doesnt wrap will pick records after that it will not pick records as it doesnt satisfy the where clause
Regards
Ragu
Ragu