topic Re: Select Query in Application Development and Automation Discussions

Select Query

Former Member — Tue, 29 Jul 2008 10:27:14 GMT

Hi,

I have written the following select query in my code :

select tabname ddlanguage as4local as4vers ddtext from dd02t into table i_tdata where tabname like 'LA*' and ddlanguage = 'E'.

The query is not retrieving any records. Can you please help.

Thanks,

Sachin.

Re: Select Query

Former Member — Tue, 29 Jul 2008 10:29:08 GMT

Corrected code...

select tabname
          ddlanguage 
          as4local 
          as4vers
          ddtext
    from dd02t
    into table i_tdata 
    where tabname like 'LA%' and 
             ddlanguage = 'E'.

Re: Select Query

Former Member — Tue, 29 Jul 2008 10:29:55 GMT

hi,

do this way ..


select tabname ddlanguage as4local as4vers ddtext from dd02t into table i_tdata where tabname like 'LA%' and ddlanguage = 'E'.

Re: Select Query

JozsefSzikszai — Tue, 29 Jul 2008 10:30:08 GMT

hi,

pls. try:

tabname like 'LA%'

(percentage instead of asterisk)

hope this helps

Re: Select Query

Former Member — Tue, 29 Jul 2008 10:30:40 GMT

Try this:

select tabname ddlanguage as4local as4vers ddtext from dd02t into table i_tdata where tabname like 'LA%' and ddlanguage = 'E'.

Regards,

Joy.

Re: Select Query

Former Member — Tue, 29 Jul 2008 10:30:42 GMT

tabname like 'LA%'

Re: Select Query

Former Member — Tue, 29 Jul 2008 10:33:59 GMT

Hi,

Use % symbol instead of *

Re: Select Query

Former Member — Tue, 29 Jul 2008 10:34:15 GMT

Thanks Vijay and all of others. It worked.