RE: [sqr-users] error while reading a string from a column

["Alexander, Steven" <Steven.Alexander@sanjoseca.gov>]

What do you mean "I am not able to read it as single string"?  Are you
saying there is a problem in the begin-select statement?  What happens when
you try to read it?

-----Original Message-----
From: sqr-users-bounces+steven.alexander=sanjoseca.gov@sqrug.org
[mailto:sqr-users-bounces+steven.alexander=sanjoseca.gov@sqrug.org] On
Behalf Of Knapp, Richard
Sent: Wednesday, April 25, 2007 7:33 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] error while reading a string from a column


Maybe translate will work for you.

Richard Knapp
EAS - Data Warehouse Group
University of Missouri
615 Locust Street  #200
Columbia, MO 65201
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
rose kunwar
Sent: Tuesday, April 24, 2007 9:19 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] error while reading a string from a column

Hi all,

How do I read a string with special characters (like comma) Here is what
I am trying to do.
|
|
open 1 for writing....... 

Begin-select
a.emplid
a.first_name
  move &a.emplid to $emplid
  move &a.first_name to $firstname
from ps_personal_data.
|
|
|
write 1 from 
  $emplid '|'
  $firstname '|'
|
|
The result should be like this:
01|jack|
02|mike|
|
|
but
if $firstname has hyphen, then I am not able to read it as single
string, so that I can write that value within same delimiter. Please
help...kind of urgent

Rose



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users