IBM i Global

Hi,

Rather than selecting select field1,field2,... field99 from a file if i want to omit only certain fields and let the other fields be selected as it is so there any way for the same using select /omit criteria in sql query ?

Thanks

Hi, 

Could someone please respond to my query here, if anyone knows it's answer? 

Thanks much... 

Hi,

Rather than selecting select field1,field2,... field99 from a file if i want to omit only certain fields and let the other fields be selected as it is so there any way for the same using select /omit criteria in sql query ?

Thanks

Hello,

As far as I know, Db2 for i (and most other DBMSs) does not have such function. You would need to achieve equivalent functionality in one of the following ways.

• Create a view or new table which has only the columns you need.
• Use any trick described in "Exclude a column using SELECT * [except columnA] FROM tableA?"
• Use RCAC if you simply do not want to show the value of a particular column.

Hope this helps.

Hi, 

Could someone please respond to my query here, if anyone knows it's answer? 

Thanks much... 

Hi,

Rather than selecting select field1,field2,... field99 from a file if i want to omit only certain fields and let the other fields be selected as it is so there any way for the same using select /omit criteria in sql query ?

Thanks

An alternative is to define those columns that you do NOT want to see as IMPLICITLY HIDDEN. There are some caveats behind doing that on inserting rows in to the table; default value etc., but if your SQL statement is SELECT * FROM SCHEMA.TABLE hidden columns are not returned. To view the column you need to EXPLICITLY specify it on the SELECT statement. 

Hello,

As far as I know, Db2 for i (and most other DBMSs) does not have such function. You would need to achieve equivalent functionality in one of the following ways.

• Create a view or new table which has only the columns you need.
• Use any trick described in "Exclude a column using SELECT * [except columnA] FROM tableA?"
• Use RCAC if you simply do not want to show the value of a particular column.

Hope this helps.

Hi, 

Could someone please respond to my query here, if anyone knows it's answer? 

Thanks much... 

Hi,

Rather than selecting select field1,field2,... field99 from a file if i want to omit only certain fields and let the other fields be selected as it is so there any way for the same using select /omit criteria in sql query ?

Thanks

Hi,

Thanks for the response here but when I tried below SQL query just for example:-

" SELECT * EXCEPT(FIELD1,FIELD2)                         

FROM mylib/myfile        "           

Then I got this error:" Keyword EXCEPT not expected. Valid tokens: FROM INTO.  

And creating a view here will also involve selecting all those desired columns one by one so it looks it will be adding extra step here.

· And what does 'Use RCAC if you simply do not want to show the value of a particular column.' What does It mean here? could someone please clarify it in detail?

"An alternative is to define those columns that you do NOT want to see as IMPLICITLY HIDDEN. There are some caveats behind doing that on inserting rows in to the table; default value etc., but if your SQL statement is SELECT * FROM SCHEMA.TABLE hidden columns are not returned. To view the column you need to EXPLICITLY specify it on the SELECT statement. "

Any example with SQL query for this 'IMPLICITLY HIDDEN' SQL Query for above point please?

Thanks much….

Original Message:
Sent: Tue July 30, 2024 03:51 AM
From: Keith Pryke
Subject: Omitting certain fields from a file using sql query

An alternative is to define those columns that you do NOT want to see as IMPLICITLY HIDDEN. There are some caveats behind doing that on inserting rows in to the table; default value etc., but if your SQL statement is SELECT * FROM SCHEMA.TABLE hidden columns are not returned. To view the column you need to EXPLICITLY specify it on the SELECT statement. 

Hello,

As far as I know, Db2 for i (and most other DBMSs) does not have such function. You would need to achieve equivalent functionality in one of the following ways.

• Create a view or new table which has only the columns you need.
• Use any trick described in "Exclude a column using SELECT * [except columnA] FROM tableA?"
• Use RCAC if you simply do not want to show the value of a particular column.

Hope this helps.

Hi, 

Could someone please respond to my query here, if anyone knows it's answer? 

Thanks much... 

Hi,

Rather than selecting select field1,field2,... field99 from a file if i want to omit only certain fields and let the other fields be selected as it is so there any way for the same using select /omit criteria in sql query ?

Thanks

EXCEPT is not a valid keyword for Db2i. That won't work. 

RCAC is Row Column Access Control. See https://www.ibm.com/docs/en/i/7.5?topic=overview-row-column-access-control

You define a column as IMPLICITLY HIDDEN. See https://www.ibm.com/docs/en/i/7.5?topic=statements-alter-table for syntax. You can also define this attribute on the CREATE TABLE SQL statement. 

Hi,

Thanks for the response here but when I tried below SQL query just for example:-

" SELECT * EXCEPT(FIELD1,FIELD2)                         

FROM mylib/myfile        "           

Then I got this error:" Keyword EXCEPT not expected. Valid tokens: FROM INTO.  

And creating a view here will also involve selecting all those desired columns one by one so it looks it will be adding extra step here.

· And what does 'Use RCAC if you simply do not want to show the value of a particular column.' What does It mean here? could someone please clarify it in detail?

"An alternative is to define those columns that you do NOT want to see as IMPLICITLY HIDDEN. There are some caveats behind doing that on inserting rows in to the table; default value etc., but if your SQL statement is SELECT * FROM SCHEMA.TABLE hidden columns are not returned. To view the column you need to EXPLICITLY specify it on the SELECT statement. "

Any example with SQL query for this 'IMPLICITLY HIDDEN' SQL Query for above point please?

Thanks much….

Original Message:
Sent: Tue July 30, 2024 03:51 AM
From: Keith Pryke
Subject: Omitting certain fields from a file using sql query

An alternative is to define those columns that you do NOT want to see as IMPLICITLY HIDDEN. There are some caveats behind doing that on inserting rows in to the table; default value etc., but if your SQL statement is SELECT * FROM SCHEMA.TABLE hidden columns are not returned. To view the column you need to EXPLICITLY specify it on the SELECT statement. 

Hello,

As far as I know, Db2 for i (and most other DBMSs) does not have such function. You would need to achieve equivalent functionality in one of the following ways.

• Create a view or new table which has only the columns you need.
• Use any trick described in "Exclude a column using SELECT * [except columnA] FROM tableA?"
• Use RCAC if you simply do not want to show the value of a particular column.

Hope this helps.

Hi, 

Could someone please respond to my query here, if anyone knows it's answer? 

Thanks much... 

Hi,

Rather than selecting select field1,field2,... field99 from a file if i want to omit only certain fields and let the other fields be selected as it is so there any way for the same using select /omit criteria in sql query ?

Thanks

Thanks for 'IMPLICITY HIDDEN' in the mentioned IBM i link but I could not find any real example there.

If anyone has any example with any SQL query example using the same here, then could someone please share the same here explaining this?

Thanks much...

EXCEPT is not a valid keyword for Db2i. That won't work. 

RCAC is Row Column Access Control. See https://www.ibm.com/docs/en/i/7.5?topic=overview-row-column-access-control

You define a column as IMPLICITLY HIDDEN. See https://www.ibm.com/docs/en/i/7.5?topic=statements-alter-table for syntax. You can also define this attribute on the CREATE TABLE SQL statement. 

Hi,

Thanks for the response here but when I tried below SQL query just for example:-

" SELECT * EXCEPT(FIELD1,FIELD2)                         

FROM mylib/myfile        "           

Then I got this error:" Keyword EXCEPT not expected. Valid tokens: FROM INTO.  

And creating a view here will also involve selecting all those desired columns one by one so it looks it will be adding extra step here.

· And what does 'Use RCAC if you simply do not want to show the value of a particular column.' What does It mean here? could someone please clarify it in detail?

"An alternative is to define those columns that you do NOT want to see as IMPLICITLY HIDDEN. There are some caveats behind doing that on inserting rows in to the table; default value etc., but if your SQL statement is SELECT * FROM SCHEMA.TABLE hidden columns are not returned. To view the column you need to EXPLICITLY specify it on the SELECT statement. "

Any example with SQL query for this 'IMPLICITLY HIDDEN' SQL Query for above point please?

Thanks much….

Original Message:
Sent: Tue July 30, 2024 03:51 AM
From: Keith Pryke
Subject: Omitting certain fields from a file using sql query

An alternative is to define those columns that you do NOT want to see as IMPLICITLY HIDDEN. There are some caveats behind doing that on inserting rows in to the table; default value etc., but if your SQL statement is SELECT * FROM SCHEMA.TABLE hidden columns are not returned. To view the column you need to EXPLICITLY specify it on the SELECT statement. 

Hello,

As far as I know, Db2 for i (and most other DBMSs) does not have such function. You would need to achieve equivalent functionality in one of the following ways.

• Create a view or new table which has only the columns you need.
• Use any trick described in "Exclude a column using SELECT * [except columnA] FROM tableA?"
• Use RCAC if you simply do not want to show the value of a particular column.

Hope this helps.

Hi, 

Could someone please respond to my query here, if anyone knows it's answer? 

Thanks much... 

Hi,

Rather than selecting select field1,field2,... field99 from a file if i want to omit only certain fields and let the other fields be selected as it is so there any way for the same using select /omit criteria in sql query ?

Thanks

Hi,

Just for example I was able to create a table here "CREATE TABLE l1/Emp (                           
    EmployeeID INT NOT NULL,                    
    FirstName VARCHAR(50),                      
    LastName VARCHAR(50) IMPLICITLY HIDDEN,     
    Salary DECIMAL(10, 2)                       
)                                               
Table EMP in L1 created but was not journaled.  "

and when I do 'select * from l1/emp' I cannot find 'LastName' here as 'IMPLICITLY HIDDEN' has been specified against this field name here, but my question here is like suppose there is a file which already exists ( and we are not sure whether this 'IMPLICTLY HIDDEN' has already been used while forming that table/file or not  in it's DDS) in the system then how can we filter out I mean omit certain fields and select rest other fields so any example for the same using this 'IMLICITLY HIDDEN' here please for SELECT SQL query here please ?

Thanks much...

Thanks for 'IMPLICITY HIDDEN' in the mentioned IBM i link but I could not find any real example there.

If anyone has any example with any SQL query example using the same here, then could someone please share the same here explaining this?

Thanks much...

EXCEPT is not a valid keyword for Db2i. That won't work. 

RCAC is Row Column Access Control. See https://www.ibm.com/docs/en/i/7.5?topic=overview-row-column-access-control

You define a column as IMPLICITLY HIDDEN. See https://www.ibm.com/docs/en/i/7.5?topic=statements-alter-table for syntax. You can also define this attribute on the CREATE TABLE SQL statement. 

Hi,

Thanks for the response here but when I tried below SQL query just for example:-

" SELECT * EXCEPT(FIELD1,FIELD2)                         

FROM mylib/myfile        "           

Then I got this error:" Keyword EXCEPT not expected. Valid tokens: FROM INTO.  

And creating a view here will also involve selecting all those desired columns one by one so it looks it will be adding extra step here.

· And what does 'Use RCAC if you simply do not want to show the value of a particular column.' What does It mean here? could someone please clarify it in detail?

"An alternative is to define those columns that you do NOT want to see as IMPLICITLY HIDDEN. There are some caveats behind doing that on inserting rows in to the table; default value etc., but if your SQL statement is SELECT * FROM SCHEMA.TABLE hidden columns are not returned. To view the column you need to EXPLICITLY specify it on the SELECT statement. "

Any example with SQL query for this 'IMPLICITLY HIDDEN' SQL Query for above point please?

Thanks much….

Original Message:
Sent: Tue July 30, 2024 03:51 AM
From: Keith Pryke
Subject: Omitting certain fields from a file using sql query

An alternative is to define those columns that you do NOT want to see as IMPLICITLY HIDDEN. There are some caveats behind doing that on inserting rows in to the table; default value etc., but if your SQL statement is SELECT * FROM SCHEMA.TABLE hidden columns are not returned. To view the column you need to EXPLICITLY specify it on the SELECT statement. 

Hello,

As far as I know, Db2 for i (and most other DBMSs) does not have such function. You would need to achieve equivalent functionality in one of the following ways.

• Create a view or new table which has only the columns you need.
• Use any trick described in "Exclude a column using SELECT * [except columnA] FROM tableA?"
• Use RCAC if you simply do not want to show the value of a particular column.

Hope this helps.

Hi, 

Could someone please respond to my query here, if anyone knows it's answer? 

Thanks much... 

Hi,

Rather than selecting select field1,field2,... field99 from a file if i want to omit only certain fields and let the other fields be selected as it is so there any way for the same using select /omit criteria in sql query ?

Thanks

select * from qsys2.syscolumns where table_schema = 'L1' and table_name = 'EMP' ;

This will return column information about the table you just created. There is a column there called HIDDEN that will tell you if it is hidden or not. Just replace the table_schema and table_name where clause values for the table you want to query. You could build the SELECT statement from that. 

Hi,

Just for example I was able to create a table here "CREATE TABLE l1/Emp (                           
    EmployeeID INT NOT NULL,                    
    FirstName VARCHAR(50),                      
    LastName VARCHAR(50) IMPLICITLY HIDDEN,     
    Salary DECIMAL(10, 2)                       
)                                               
Table EMP in L1 created but was not journaled.  "

and when I do 'select * from l1/emp' I cannot find 'LastName' here as 'IMPLICITLY HIDDEN' has been specified against this field name here, but my question here is like suppose there is a file which already exists ( and we are not sure whether this 'IMPLICTLY HIDDEN' has already been used while forming that table/file or not  in it's DDS) in the system then how can we filter out I mean omit certain fields and select rest other fields so any example for the same using this 'IMLICITLY HIDDEN' here please for SELECT SQL query here please ?

Thanks much...

Thanks for 'IMPLICITY HIDDEN' in the mentioned IBM i link but I could not find any real example there.

If anyone has any example with any SQL query example using the same here, then could someone please share the same here explaining this?

Thanks much...

EXCEPT is not a valid keyword for Db2i. That won't work. 

RCAC is Row Column Access Control. See https://www.ibm.com/docs/en/i/7.5?topic=overview-row-column-access-control

You define a column as IMPLICITLY HIDDEN. See https://www.ibm.com/docs/en/i/7.5?topic=statements-alter-table for syntax. You can also define this attribute on the CREATE TABLE SQL statement. 

Hi,

Thanks for the response here but when I tried below SQL query just for example:-

" SELECT * EXCEPT(FIELD1,FIELD2)                         

FROM mylib/myfile        "           

Then I got this error:" Keyword EXCEPT not expected. Valid tokens: FROM INTO.  

And creating a view here will also involve selecting all those desired columns one by one so it looks it will be adding extra step here.

· And what does 'Use RCAC if you simply do not want to show the value of a particular column.' What does It mean here? could someone please clarify it in detail?

"An alternative is to define those columns that you do NOT want to see as IMPLICITLY HIDDEN. There are some caveats behind doing that on inserting rows in to the table; default value etc., but if your SQL statement is SELECT * FROM SCHEMA.TABLE hidden columns are not returned. To view the column you need to EXPLICITLY specify it on the SELECT statement. "

Any example with SQL query for this 'IMPLICITLY HIDDEN' SQL Query for above point please?

Thanks much….

Original Message:
Sent: Tue July 30, 2024 03:51 AM
From: Keith Pryke
Subject: Omitting certain fields from a file using sql query

An alternative is to define those columns that you do NOT want to see as IMPLICITLY HIDDEN. There are some caveats behind doing that on inserting rows in to the table; default value etc., but if your SQL statement is SELECT * FROM SCHEMA.TABLE hidden columns are not returned. To view the column you need to EXPLICITLY specify it on the SELECT statement. 

Hello,

As far as I know, Db2 for i (and most other DBMSs) does not have such function. You would need to achieve equivalent functionality in one of the following ways.

• Create a view or new table which has only the columns you need.
• Use any trick described in "Exclude a column using SELECT * [except columnA] FROM tableA?"
• Use RCAC if you simply do not want to show the value of a particular column.

Hope this helps.

Hi, 

Could someone please respond to my query here, if anyone knows it's answer? 

Thanks much... 

Hi,

Rather than selecting select field1,field2,... field99 from a file if i want to omit only certain fields and let the other fields be selected as it is so there any way for the same using select /omit criteria in sql query ?

Thanks

I think my query is still misunderstood here what I meant to ask was that if a table let's say it's not created using this 'implict hidden' then in such table/file how will we be able use SELECT query to get only those columns whose records we want to see excluding certain fields from that table/file? 

Also i tried this SQL query it shows data here like :- 

What does these 'N' and 'P' mean here?

Thanks..

select * from qsys2.syscolumns where table_schema = 'L1' and table_name = 'EMP' ;

This will return column information about the table you just created. There is a column there called HIDDEN that will tell you if it is hidden or not. Just replace the table_schema and table_name where clause values for the table you want to query. You could build the SELECT statement from that. 

Hi,

Just for example I was able to create a table here "CREATE TABLE l1/Emp (                           
    EmployeeID INT NOT NULL,                    
    FirstName VARCHAR(50),                      
    LastName VARCHAR(50) IMPLICITLY HIDDEN,     
    Salary DECIMAL(10, 2)                       
)                                               
Table EMP in L1 created but was not journaled.  "

and when I do 'select * from l1/emp' I cannot find 'LastName' here as 'IMPLICITLY HIDDEN' has been specified against this field name here, but my question here is like suppose there is a file which already exists ( and we are not sure whether this 'IMPLICTLY HIDDEN' has already been used while forming that table/file or not  in it's DDS) in the system then how can we filter out I mean omit certain fields and select rest other fields so any example for the same using this 'IMLICITLY HIDDEN' here please for SELECT SQL query here please ?

Thanks much...

Thanks for 'IMPLICITY HIDDEN' in the mentioned IBM i link but I could not find any real example there.

If anyone has any example with any SQL query example using the same here, then could someone please share the same here explaining this?

Thanks much...

EXCEPT is not a valid keyword for Db2i. That won't work. 

RCAC is Row Column Access Control. See https://www.ibm.com/docs/en/i/7.5?topic=overview-row-column-access-control

You define a column as IMPLICITLY HIDDEN. See https://www.ibm.com/docs/en/i/7.5?topic=statements-alter-table for syntax. You can also define this attribute on the CREATE TABLE SQL statement. 

Hi,

Thanks for the response here but when I tried below SQL query just for example:-

" SELECT * EXCEPT(FIELD1,FIELD2)                         

FROM mylib/myfile        "           

Then I got this error:" Keyword EXCEPT not expected. Valid tokens: FROM INTO.  

And creating a view here will also involve selecting all those desired columns one by one so it looks it will be adding extra step here.

· And what does 'Use RCAC if you simply do not want to show the value of a particular column.' What does It mean here? could someone please clarify it in detail?

"An alternative is to define those columns that you do NOT want to see as IMPLICITLY HIDDEN. There are some caveats behind doing that on inserting rows in to the table; default value etc., but if your SQL statement is SELECT * FROM SCHEMA.TABLE hidden columns are not returned. To view the column you need to EXPLICITLY specify it on the SELECT statement. "

Any example with SQL query for this 'IMPLICITLY HIDDEN' SQL Query for above point please?

Thanks much….

Original Message:
Sent: Tue July 30, 2024 03:51 AM
From: Keith Pryke
Subject: Omitting certain fields from a file using sql query

An alternative is to define those columns that you do NOT want to see as IMPLICITLY HIDDEN. There are some caveats behind doing that on inserting rows in to the table; default value etc., but if your SQL statement is SELECT * FROM SCHEMA.TABLE hidden columns are not returned. To view the column you need to EXPLICITLY specify it on the SELECT statement. 

Hello,

As far as I know, Db2 for i (and most other DBMSs) does not have such function. You would need to achieve equivalent functionality in one of the following ways.

• Create a view or new table which has only the columns you need.
• Use any trick described in "Exclude a column using SELECT * [except columnA] FROM tableA?"
• Use RCAC if you simply do not want to show the value of a particular column.

Hope this helps.

Hi, 

Could someone please respond to my query here, if anyone knows it's answer? 

Thanks much... 

Hi,

Rather than selecting select field1,field2,... field99 from a file if i want to omit only certain fields and let the other fields be selected as it is so there any way for the same using select /omit criteria in sql query ?

Thanks

Hi,

Thanks for the response here but when I tried below SQL query just for example:-

" SELECT * EXCEPT(FIELD1,FIELD2)                         

FROM mylib/myfile        "           

Then I got this error:" Keyword EXCEPT not expected. Valid tokens: FROM INTO.  

And creating a view here will also involve selecting all those desired columns one by one so it looks it will be adding extra step here.

· And what does 'Use RCAC if you simply do not want to show the value of a particular column.' What does It mean here? could someone please clarify it in detail?

"An alternative is to define those columns that you do NOT want to see as IMPLICITLY HIDDEN. There are some caveats behind doing that on inserting rows in to the table; default value etc., but if your SQL statement is SELECT * FROM SCHEMA.TABLE hidden columns are not returned. To view the column you need to EXPLICITLY specify it on the SELECT statement. "

Any example with SQL query for this 'IMPLICITLY HIDDEN' SQL Query for above point please?

Thanks much….

Original Message:
Sent: Tue July 30, 2024 03:51 AM
From: Keith Pryke
Subject: Omitting certain fields from a file using sql query

An alternative is to define those columns that you do NOT want to see as IMPLICITLY HIDDEN. There are some caveats behind doing that on inserting rows in to the table; default value etc., but if your SQL statement is SELECT * FROM SCHEMA.TABLE hidden columns are not returned. To view the column you need to EXPLICITLY specify it on the SELECT statement. 

Hello,

As far as I know, Db2 for i (and most other DBMSs) does not have such function. You would need to achieve equivalent functionality in one of the following ways.

• Create a view or new table which has only the columns you need.
• Use any trick described in "Exclude a column using SELECT * [except columnA] FROM tableA?"
• Use RCAC if you simply do not want to show the value of a particular column.

Hope this helps.

Hi, 

Could someone please respond to my query here, if anyone knows it's answer? 

Thanks much... 

Hi,

Rather than selecting select field1,field2,... field99 from a file if i want to omit only certain fields and let the other fields be selected as it is so there any way for the same using select /omit criteria in sql query ?

Thanks

> What does It mean here?

If the purpose of excluding certain columns is "not to show sensitive values such as salary," RCAC would be suitable.

As mentioned previously, there are several ways to exclude certain columns with "SELECT *" as discussed in "Exclude a column using SELECT * [except columnA] FROM tableA?". For example,

a) Create temporary table : Realistic for small DB. Run "ADDRPYLE SEQNBR(99) MSGID(CPA32B2) RPY(I)" in advance. 

SELECT * FROM QIWS.QCUSTCDT;
CREATE OR REPLACE TABLE QTEMP.QCUSTCDT AS (SELECT * FROM QIWS.QCUSTCDT) WITH DATA ON REPLACE DELETE ROWS; 
CL:CHGJOB INQMSGRPY(*SYSRPYL);
ALTER TABLE QTEMP.QCUSTCDT DROP COLUMN BALDUE; 
SELECT * FROM QTEMP.QCUSTCDT;

b) Create view : Efficient for continuous use. May be inefficient if you want to exclude columns dynamically or have a large number of exclusion patterns.

For example, a list of columns for a particular table can be obtained from the SYSCOLUMNS table.

SELECT COLUMN_NAME || ',' AS COLUMNS  FROM QSYS2.SYSCOLUMNS WHERE TABLE_NAME = 'QCUSTCDT' AND TABLE_SCHEMA = 'QIWS'

Create a View by deleting unnecessary columns from the list of columns.

----

To get the desired answer, please explain the purpose of excluding certain columns.

If the table is to be processed by an embedded SQL program, it does not matter if some columns are not used, as they can simply be ignored by the logic. If you have a table that you want to make available to the public through a query, SQL script, ACS download, etc., and this table contains columns that you want to keep private, you can implement security with RCAC.

Hi,

Thanks for the response here but when I tried below SQL query just for example:-

" SELECT * EXCEPT(FIELD1,FIELD2)                         

FROM mylib/myfile        "           

Then I got this error:" Keyword EXCEPT not expected. Valid tokens: FROM INTO.  

And creating a view here will also involve selecting all those desired columns one by one so it looks it will be adding extra step here.

· And what does 'Use RCAC if you simply do not want to show the value of a particular column.' What does It mean here? could someone please clarify it in detail?

"An alternative is to define those columns that you do NOT want to see as IMPLICITLY HIDDEN. There are some caveats behind doing that on inserting rows in to the table; default value etc., but if your SQL statement is SELECT * FROM SCHEMA.TABLE hidden columns are not returned. To view the column you need to EXPLICITLY specify it on the SELECT statement. "

Any example with SQL query for this 'IMPLICITLY HIDDEN' SQL Query for above point please?

Thanks much….

Original Message:
Sent: Tue July 30, 2024 03:51 AM
From: Keith Pryke
Subject: Omitting certain fields from a file using sql query

An alternative is to define those columns that you do NOT want to see as IMPLICITLY HIDDEN. There are some caveats behind doing that on inserting rows in to the table; default value etc., but if your SQL statement is SELECT * FROM SCHEMA.TABLE hidden columns are not returned. To view the column you need to EXPLICITLY specify it on the SELECT statement. 

Hello,

As far as I know, Db2 for i (and most other DBMSs) does not have such function. You would need to achieve equivalent functionality in one of the following ways.

• Create a view or new table which has only the columns you need.
• Use any trick described in "Exclude a column using SELECT * [except columnA] FROM tableA?"
• Use RCAC if you simply do not want to show the value of a particular column.

Hope this helps.

Hi, 

Could someone please respond to my query here, if anyone knows it's answer? 

Thanks much... 

Hi,

Rather than selecting select field1,field2,... field99 from a file if i want to omit only certain fields and let the other fields be selected as it is so there any way for the same using select /omit criteria in sql query ?

Thanks