Re: Table Definition in System i Navigator V6R1

Thanks Gary,



If I right click Connection --> Diagnostics --> Verify Connection
everything gets a Successfully Connected response.



I tried several other schemas and got the same two data types CHARACTER
and ROWID when adding a new column.



I can run sql scripts but there is nothing about data types in the
resulting job log. The other strange thing is that if I Right Click on an
existing table and select Definition it shows other data types for the
existing columns. If I click on one of these and select Definition it just
shows whatever that field definition is and ROWID. For example if I click
on a field which already exists in a table which is defined as Numeric and
click on the Definition button the Data Types drop down just shows NUMERIC
and ROWID.



I would post some screen shots but am not sure how.



Has anyone else experienced this problem?


Adam Mills
Snr Technical Consultant, Island Pacific
Direct: +44 (0)7739 941855
Any reference to or discussion regarding existing contracts in the body of
this email will not otherwise alter the terms and conditions of our
existing contracts - which other than any temporary change described in the
body of this email remains in full force





-----Original Message-----
From: Gary Thompson [mailto:gthompson@xxxxxxxxxxx]
Sent: 25 May 2012 14:13
To: Midrange Systems Technical Discussion
Subject: RE: Table Definition in System i Navigator V6R1



Adam,

Not much comes to mind, but here are some guesses:

1_ maybe something missing on the i server or your client:

What does right-click on your connection/diagnostics show?

2_ maybe something about the Schema you selected

I have tried about 6 on my main connection and have not

been able to re-produce your issue, but...

3_ from run sql scripts, you can easily see the job log of the

host job supporting your connection so maybe you

can see a message in your host connection job log

relevant to your Data Types issue...

On our system, I find the job for my connections

in Subsystem QSERVER, with job name of QZDASOINIT

and a Current User equal my user profile



I did check Paul Tuohy's Programmer's Guide to iSeries Navigator,

but did not see anything Data Types not appearing.



Hopefully someone else will be able to help



-----Original Message-----

From: midrange-l-bounces@xxxxxxxxxxxx<mailto:
midrange-l-bounces@xxxxxxxxxxxx> [mailto:midrange-l-bounces@xxxxxxxxxxxx]
On Behalf Of Adam Mills

Sent: Friday, May 25, 2012 1:30 AM

To: midrange-l@xxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxx>

Subject: RE: Table Definition in System i Navigator V6R1



Gary,



Yes I am in the New Table -> Add Column tab. I only see 'Character' and
'Rowid' when I click on Data Types. Similarly if I try and amend or add a
column to an existing table I still only get the choice of these two types.



Thanks



Adam Mills

Snr Technical Consultant, Island Pacific

Direct: +44 (0)7739 941855

Any reference to or discussion regarding existing contracts in the body of
this email will not otherwise alter the terms and conditions of our
existing contracts - which other than any temporary change described in the
body of this email remains in full force





message: 2

date: Wed, 23 May 2012 10:42:11 -0700

from: Adam Mills <amills@xxxxxxxxxxxxxxxxx<mailto:amills@xxxxxxxxxxxxxxxxx

subject: Table Definition in System i Navigator V6R1



Hello,



I am trying to create a physical file on the iSeries using System i
Navigator and the table definition option within Databases --> Schemas -->
Tables.



When I click on the Columns tab and the Data type drop down box I only see
two selectable data types, Character and Rowid. This is on my V6R1
partition. On my V5R4 partition I see all of the data types such as
Character, CLOB, Decimal etc. The version of System i Navigator I am using
is V6R1M0 Service level SI42423.



I have attached screen shots showing this. Has anyone encountered anything
similar and do they know why I can only see two data types and what I can
do to see the rest?



Thanks



Adam Mills



[cid:image001.jpg@01CD3913.C3F2E610]<http://www.islandpacific.com/>



Snr Technical Consultant

P 07739 941855

F 01279.874551

amills@xxxxxxxxxxxxxxxxx<mailto:amills@xxxxxxxxxxxxxxxxx>






--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.