topic Re: Inserting Field in Table in Application Development and Automation Discussions

Inserting Field in Table

Former Member — Tue, 27 Feb 2007 07:27:15 GMT

Hi..

I have added a new field FIELD_1 (domain CHAR10) to a already existing Z table, recreated the "Table Maintenance Generator" and transported the table to Test server. Test data exists on test server with some records having FIELD_1 populated and others having FIELD_1 blank.

The following query when executed on test server fetches no records though many records satisfying the WHERE condition exists.

SELECT *

FROM ZDODATA

INTO IT_ZDODATA

WHERE FIELD_1 EQ SPACE.

Also, it should be noted that the below query fetches proper records as expected.

SELECT *

FROM ZDODATA

INTO IT_ZDODATA

WHERE FIELD_1 NE SPACE.

Why does the first query fail to fetch records?

Regards,

Anoop

Re: Inserting Field in Table

Former Member — Tue, 27 Feb 2007 09:45:43 GMT

1) for the first query since you are selecting a field whose value is space it does not fetch anything

2) for the second query you are selecting which has some value so it fetch the data

Re: Inserting Field in Table

former_member195698 — Tue, 27 Feb 2007 13:26:13 GMT

try "regeneration of the table maintenance" again checking all the options that come for deletion.

Ideally there should be no issues in the queries as queries are correct.

Re: Inserting Field in Table

emjay — Tue, 27 Feb 2007 22:28:52 GMT

Try to replace the first query like

SELECT *

FROM ZDODATA

INTO IT_ZDODATA

WHERE FIELD_1 IS INITIAL.

Hope this helps.

EmJay

Assign Points if useful

Re: Inserting Field in Table

Former Member — Wed, 28 Feb 2007 00:17:14 GMT

If the first query is not fetching the records, then it means the records which you think are null, doesn't contain SPACE value in them. Please, check it out by urself wat exactly the value of tht particular field instaed of SPACE. You can definately use INITIAL. try it out.

If solved, then please close the thread.

Thanks

Ashwani

Re: Inserting Field in Table

Former Member — Wed, 28 Feb 2007 03:14:02 GMT

Check whether the <b>fieldl_1 is NULL.</b>

Hope this quey got answered in the earlier thread.

Re: Inserting Field in Table

jayanthi_jayaraman — Wed, 28 Feb 2007 04:04:32 GMT

Hi,

Here f3 is the field added recently.This is giving the results as expected.

data itab type standard table of zzzz_test.

data wa type zzzz_test.

select * from zzzz_test into table itab where f3 is null.

Re: Inserting Field in Table

Former Member — Wed, 28 Feb 2007 04:56:10 GMT

The Statement

SELECT *

FROM ZDODATA

INTO IT_ZDODATA

WHERE FIELD_1 IS INITIAL

gives syntax error: The operator IS can only be used in "f IS NULL" or "f IS NOT NULL".

However, WHERE FIELD_1 IS NULL serves my purpose.

Thanks & Regards,

Anoop

Re: Inserting Field in Table

Former Member — Wed, 28 Feb 2007 05:06:49 GMT

u can put like this

The Statement

SELECT *

FROM ZDODATA

INTO IT_ZDODATA

<b>WHERE FIELD_1 eq space.

WHERE FIELD_1 ne space.</b>

Regards

Prabhu