« Comparison between SAP HANA with SAP Sybase IQ – first impressions | Main | Effective usage of sampling for update statistics in ASE »

03 November 2013

Comments

Feed You can follow this conversation by subscribing to the comment feed for this post.

sreedhar

HI,
Please help me

My query is
how to split Multi character delimiter in sybase database.

for example: String is "hihow@$#iamfine@$#howu r@$#sorry"
ouput is :
hihow
iamfine
howur
sorry.

Leonid Gvirtz

Hi

Your comment seems to be not related to my post, but anyway:
I suppose that the number of delimited values in the row is not known in advance. I don't see any easy way to solve this problem in ASE. If you want to do it generic, you may want to implement something similar to sp_lg_print_table procedure, that can be found in Downloads section on my website. The procedure allows to unpivot any result set. Since your input is not really a result set (no real columns), you will need to do some extra work to discover at least the number of delimited values ("columns") in your input.
I think that the better way to solve this problem is not to try to solve it directly, any solution will be poorly scalable. Sometimes, changing of the design is the best way to go. Another possible option is to parse your delimited string on the client.

Mr M

I have a very large table (millions of rows) that is inserted/updated hundreds of times a minute that is the bulk of the MV. If I turn on automatic update of the MV this will surely dramaticalky slow down the insert/update to this key table which I cannot afford to happen. And if I do manual updating of MV the MV data will be stale.... Miffed!

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment

Your Information

(Name and email address are required. Email address will not be displayed with the comment.)

My Photo

About Me

  • My name is Leonid Gvirtz, I'm freelance consultant in database-related areas. I work with various database-related technologies since 1995. I have a vast amount of experience in the design of databases and database-oriented applications, implementation, troubleshooting, performance & tuning, monitoring, and training.

January 2014

Sun Mon Tue Wed Thu Fri Sat
      1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31