MVSFORUMS.com

Thanks so much .I understand now and it helped me and I was able to get my results.

GuyC,

Thanks for the reply but I am not clear what exactly you are trying to do.Plus I am in DB2 V9 CM Mode so cannot use New Function mode.I did try using both the formats and
I get the below er ...

Hi,

I have a DB2 Table with some columns and some columns are as belowSelect Column Name Col No Col Type Length Scale Null Def FP
* * * * * * ...

GuyC,

Your code worked and gave me the results what I desired . Thanks for your help.

I am trying to write a query to get a desired output. Below is the DDL code and DML code.

CREATE TABLE TEST.TBABE
( ...

Thanks Kolusu and John , that works much better solution.

Thanks Dick and Semigeezer,

My saved list is in dataset TEST.LIST.DATASETS. A small clarification , in the Rexx code , the way I have included the name after DA , is it correct.Now what my underst ...

Hi All,

I have a list of datasets which I have saved in 3.4 by SAVE LIST command.What I need is to find out all empty datasets from that list and store in a seperate dataset.I did try by using PRIN ...

Kolusu,

Thanks so much for your query and I was able to get my desired result.

NASCAR9,

Your query failed with -206:

DSNT408I SQLCODE = -206, ERROR: A.PROGNAME IS NOT A COLUMN OF AN I ...

I have data in Table A as below:

SELECT * FROM YADAV.A;
---------+---------+---------+---------+---------+---------+---------+---------+
...

Kolusu,

I am in DB2 V8 only . Is there any way to achieve the same.

I have two base tables with millions of records.The view is a simple select of columns from the two different tables with a where condition.With the count of records being huge,I am trying to create ...

Kolusu,

I might be lacking basics here. But -158 incidates that the column which I want an additional in the View creation is not present in the base table , as the column numbers does not match. I ...

Yes because the columns which I am having in my View creation do not match in count in the Select from columns from base table.

Kolusu,

Can you please help me fix the problem. My view creation is not successful.