Re^2: Extracting only required length in a column in perl DBI

That will work.. But, I actually wanted to extract 6 characters for the 3 column... How do I achieve that??

Comment on Re^2: Extracting only required length in a column in perl DBI

Replies are listed 'Best First'.
Re^3: Extracting only required length in a column in perl DBI by marto (Cardinal) on Jan 15, 2013 at 12:53 UTC
Replace the 3 in my example with a 6, you should consider learning basic SQL.	[reply]
Re^4: Extracting only required length in a column in perl DBI by Thomas Kennll (Acolyte) on Jan 15, 2013 at 13:08 UTC
What I meant is something like this my ($ansb_cktid, $ansb_mcn, $ansb_soc) =unpack("A3 A3 A6")	[reply]
Re^5: Extracting only required length in a column in perl DBI by marto (Cardinal) on Jan 15, 2013 at 14:02 UTC
I'm of the mind set that you shouldn't pull back more data than you need then post process it, when you can easily return only what you need.	[reply]