Re: Inserting to a bigint data type in Sybase using prepare statements

Implicit conversion from datatype 'VARCHAR' to 'BIGINT' is not allowed. Use the CONVERT function to run this query.

Try an explicit conversion

my $insert_sth = "
  INSERT INTO some_table 
  ( transaction_id, ccn_masked, cardholder_name, exp_month, 
    exp_year,card_type, token_id ) 
  VALUES (?, ?, ?, ?, ?, ?, CONVERT(BIGINT,?) )";
[download]

poj

Comment on Re: Inserting to a bigint data type in Sybase using prepare statements Download Code

Replies are listed 'Best First'.
Re^2: Inserting to a bigint data type in Sybase using prepare statements by j_ochoa (Novice) on Jul 07, 2017 at 13:23 UTC
Hi poj, I have also tried that, but in that case I was getting this error <Couldn't prepare statement: Server message number=12828 severity=16 state=1 line=1 server=DEVEL1 procedure=DBD3 text=The datatype of a parameter marker used in the dynamic prepare statement could not be resolved. BR JO	[reply]
Re^3: Inserting to a bigint data type in Sybase using prepare statements by chacham (Prior) on Jul 07, 2017 at 14:18 UTC
How about using INSERT...SELECT instead of INSERT...VALUES? It might be legal in that statement instead.	[reply]
Re^3: Inserting to a bigint data type in Sybase using prepare statements by poj (Abbot) on Jul 07, 2017 at 14:29 UTC
What version of Sybase, Perl and DBD::Sybase are you using ?	[reply]
Re^4: Inserting to a bigint data type in Sybase using prepare statements by j_ochoa (Novice) on Jul 10, 2017 at 06:36 UTC
Hi poj, these are the versions: Perl 5.14 DBD::Sybase 1.15 Sybase: Adaptive Server Enterprise/15.7.0/EBF 22644 SMP SP52 Thanks!	[reply]
Re^5: Inserting to a bigint data type in Sybase using prepare statements by poj (Abbot) on Jul 10, 2017 at 07:01 UTC
Re^6: Inserting to a bigint data type in Sybase using prepare statements by j_ochoa (Novice) on Jul 10, 2017 at 08:31 UTC