Hi All,
I am using one sybase database table 'XXX'as my source ,and it contains one column like 'enddate'.
and the values are like for this column in database are :
31 Dec 3999
21Aug3999 etc..
In my source sybase stage ,when i tried to add user defined qry like
select enddate from XXX where enddate = "3999-12-31"
I am getting job aborting,and below messages are getting in my director log.
Warning:
SB_XXX,0: Warning: Job1.XXX: Sybase Server warning 102 (severity 15): Incorrect syntax near '3999'.
Fatal:
XXX,0: Failure during execution of operator logic.
XXX,0: Fatal Error: Fatal: Attempt to get target table info from sp_tables failed.
SQL statement: sp_tables ""3999-12-31""\n
Can any one help me to resolve this.
Sybase Sql error
Moderators: chulett, rschirm, roy
Sybase Sql error
Thanx&Regards
scorpion
scorpion
And you're sure double quotes are valid syntax? In my experience double quotes are used as column labels, sometimes with the AS keyword. Try single quotes.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Re: Sybase Sql error
AS much i know about Sybase ase maximum date it allow is 6/6/2079
and if you fire your query mentioned in thread in isql it will give you arithmetic overflow.
and if you fire your query mentioned in thread in isql it will give you arithmetic overflow.
scorpion wrote:Hi All,
I am using one sybase database table 'XXX'as my source ,and it contains one column like 'enddate'.
and the values are like for this column in database are :
31 Dec 3999
21Aug3999 etc..
In my source sybase stage ,when i tried to add user defined qry like
select enddate from XXX where enddate = "3999-12-31"
I am getting job aborting,and below messages are getting in my director log.
Warning:
SB_XXX,0: Warning: Job1.XXX: Sybase Server warning 102 (severity 15): Incorrect syntax near '3999'.
Fatal:
XXX,0: Failure during execution of operator logic.
XXX,0: Fatal Error: Fatal: Attempt to get target table info from sp_tables failed.
SQL statement: sp_tables ""3999-12-31""\n
Can any one help me to resolve this.