http://community.actian.com/forum/ en Thu, 20 Jun 2013 00:51:27 GMT vBulletin 60 http://community.actian.com/forum/ingres4/misc/rss.jpg http://community.actian.com/forum/ http://community.actian.com/forum/vectorwise-q/15271-problems-foreign-characters.html Wed, 19 Jun 2013 10:49:11 GMT Hi, asking this here as our very expensive licence doesn't cover support for php. I've come across a few foreign characters that I can't seem to get past the driver. Has anyone else hit this?

I'm trying to import data from SQL server to VW using php (ingres driver) and I'm having a problem with one particular customer name.

>>> this for my reference
select * from customer where cust_id = 103121

>>> this is the offending customer name and the actual bytes
MUSEU D'HISTÒRIA DE CAMBRILS
77(M) 85(U) 83(S) 69(E) 85(U) 32( ) 68(D) 39(') 72(H) 73(I) 83(S) 84(T) 210(Ò) 82(R) 73(I) 65(A) 32( ) 68(D) 69(E) 32( ) 67(C) 65(A) 77(M) 66(B) 82(R) 73(I) 76(L) 83(S) 32( ) 32( ) 32( )

>>> this is after utf8_encode (works fine on most of the customer names) my terminal isn't in utf-8 mode so this looks correct to me
MUSEU D'HISTÃRIA DE CAMBRILS

>>> and trying to insert (via ingres_escape_string hence the doubled apostrophe)
line 1, Illegal character in string constant.
insert into customer_history (_key,_batchref,country_code,cust_id,start_date,en d_date,active,cust_num,cost_center,cust_name,cust_ adress,cust_city,cust_zip,cust_country,indus_secto r_id,cust_source,create_date,update_date,indus_sec tor_source) VALUES ('ES|103121','5e2a1e30-2e21-4da9-ab8b-7b5067b1b8d9','ES','103121','20000101','29991231', 'Y','G43573401','-999999999','MUSEU D''HISTÃ''RIA DE CAMBRILS ','CL VIA AUGUSTA 1','CAMBRILS','43850','ES','140','SALOME','2011-04-27 14:24:35','2012-07-27 22:13:05','SALOME') ]]> kevin_thorpe_2 http://community.actian.com/forum/vectorwise-q/15271-problems-foreign-characters.html http://community.actian.com/forum/comp-databases-ingres/15270-grant-table-fails.html Wed, 19 Jun 2013 09:45:46 GMT Creating a table and granting all to public fails. > > When I create a...]]> On Wednesday, 19 June 2013 10:45:46 UTC+1, mike...@gmail.com wrote:
> Creating a table and granting all to public fails.
>
> When I create a table in isql and grant all on the table to public, no other user can see the table.
>
> Example
>
> 1> create table mikes (col1 varchar(10))
>
>
>
>
>
> 2> grant all on mikes to public
>
>
>
>
>
> 3> commit
>
>
>
>
>
> End of Request
>
>
>
> However logging in as a different user I get
>
> 1> select * from mikes
>
>
>
> E_US0845 Table 'mikes' does not exist or is not owned by you.
>
> (Wed Jun 19 10:39:44 2013)
>
>
>
>
>
> End of Request - Terminated by Errors
>
>
>
> Running Ingres SPARC SOLARIS Version II 9.2.1 (su9.us5/103)
>
>
>
> We are doing the same thing in OpenRoad5.1 and getting the same issue.
>
>
>
> Is this a known issue and is there a patch?

Thanks for that. A schoolboy error!
]]> Comp.Databases.Ingres miked6789@gmail.com http://community.actian.com/forum/comp-databases-ingres/15270-grant-table-fails.html http://community.actian.com/forum/database-general/15269-monitoring-availability.html Wed, 19 Jun 2013 06:48:11 GMT Hello,

I need to report monthly over the availability of an application which uses Ingres.

Therefore I need to know what's the best way to create a log regarding the availability of the Ingres 9.2 database (on HPUX 11.23) so I can extract data to calculate availability over a monthly period.

Thank you! ]]> Database General imtech_ts http://community.actian.com/forum/database-general/15269-monitoring-availability.html http://community.actian.com/forum/php/15268-ingres_result_seek.html Tue, 18 Jun 2013 16:12:38 GMT hello,

I can not run ingres_result_seek.
after a ingres_query and ingres_fetch_array then, I would 'rewind' my array.
I have no php error in the execution of ingres_result_seek (my syntaxe is correct) and of course when I did another ingres_fetch_array on my array then it is empty because the cursor is left at the end.

Have you succeeded in using ingres_result_seek?

config:
Windows 2008 64bit
Ingres 9.2.1
Ingres_php.dll: 2.2.2 (revision: 300310 / Open API: 3)
PHP 5.3.8 VC9
APACHE 2.2.21

thanks for your help. ]]> PHP mrtoine http://community.actian.com/forum/php/15268-ingres_result_seek.html http://community.actian.com/forum/application-development-using-openroad/15267-image-storage-encoding-decoding.html Tue, 18 Jun 2013 15:39:01 GMT Hello. I have an openroad application that stores images into an ingres db. I want to be able to recall these image from a non-openroad... Hello. I have an openroad application that stores images into an ingres db. I want to be able to recall these image from a non-openroad application. If possible, how so? Thanks. ]]> Application Development using OpenROAD adamcox27 http://community.actian.com/forum/application-development-using-openroad/15267-image-storage-encoding-decoding.html http://community.actian.com/forum/application-development-using-openroad/15266-row-background-colour-tablefield.html Mon, 17 Jun 2013 14:31:48 GMT Is it possible to set the background colour for a row in a tablefield without referencing each cell for that row? The ultimate goal being to have... Is it possible to set the background colour for a row in a tablefield without referencing each cell for that row? The ultimate goal being to have rows alternate two different colours. For example:

####
####
####
####

But I wont want to call all of the cells by their name (because I wont know them).

Many thanks,

Adrian ]]> Application Development using OpenROAD apsmith http://community.actian.com/forum/application-development-using-openroad/15266-row-background-colour-tablefield.html http://community.actian.com/forum/ingres-community/15265-community.html Mon, 17 Jun 2013 14:25:06 GMT Hi I Want to ask about ingres community edition , is it stable for production system , are there issue might be raised in future use ,could i use... Hi

I Want to ask about ingres community edition , is it stable for production system , are there issue might be raised in future use ,could i use all features of ingres inside ?

could we run ingres for long time without fixes or patches or updates without risk ?

what is the recommended platform for community editions ?

Thanks ]]> The Ingres Community zaidmokbel http://community.actian.com/forum/ingres-community/15265-community.html http://community.actian.com/forum/database-general/15264-ingres-community-edition.html Mon, 17 Jun 2013 12:40:39 GMT Hi I Want to ask about ingres community edition , is it stable for production system , are there issue might be raised in future use ,could i... Hi

I Want to ask about ingres community edition , is it stable for production system , are there issue might be raised in future use ,could i use all features of ingres inside ?

could we run ingres for long time without fixes or patches or updates without risk ?

what is the recommended platform for community editions ?

Thanks ]]> Database General zaidmokbel http://community.actian.com/forum/database-general/15264-ingres-community-edition.html http://community.actian.com/forum/application-development-using-openroad/15263-uninstall-patch.html Mon, 17 Jun 2013 09:40:43 GMT I have installed the patch 14465 but it doesn't resolve the issue we have in our application.

Is it possible to uninstall it?

Regards ]]> Application Development using OpenROAD aemme http://community.actian.com/forum/application-development-using-openroad/15263-uninstall-patch.html http://community.actian.com/forum/ingres-community/15262-bodo-bergmann-wins-aua-community-award-last.html Wed, 12 Jun 2013 16:20:05 GMT The winner of the AUA 2013 Community Award is *Bodo Bergmann*. It is hard to know who was more pleased with the choice, Bodo or the audience, so... The winner of the AUA 2013 Community Award is Bodo Bergmann. It is hard to know who was more pleased with the choice, Bodo or the audience, so well-done Bodo and congratulations.



(Normally the award is presented by the previous year's winner but unfortunately Tomasz Konojacki was unable to attend the conference and so Kim Ginnerup stood in. Those of us who watched the presentation won't quickly forget Kim's performance. :) ]]> The Ingres Community rhann http://community.actian.com/forum/ingres-community/15262-bodo-bergmann-wins-aua-community-award-last.html http://community.actian.com/forum/ingres-database-contributions/15261-aggregation-functions-begine-end-help-please.html Wed, 12 Jun 2013 11:28:48 GMT Hi All,

I'm trying to code a new aggregation function. It needs a begin-agg, nextrow-agg and end-agg function coded into fi_defn.txt, as follows...

routine adu_N20_md5sum adu_B20_md5sum adu_E20_md5sum

I've defined the code for these routines in aduagstr.c.

Each starts with a TRdisplay("adu_N20_md5sum: entered\n"), TRdisplay("adu_B20_md5sum: entered\n") or you get the idea.

When I run the code the log in II_DBMS_LOG shows the adu_N20_md5sum alone is called. It is called the correct number of times given my test case. But neither the begin function or the end function (that I have asked for) is called!

What have I done wrong?

My fi_defn in full is:
operator ADI_MD5SUM_OP type ADI_PREFIX
name "md5sum" support ADI_INGRES_6

fi ADFI_1561_MD5SUM_STR
description char(32) : md5sum(varchar)
lenspec ADI_FIXED 32
flags ADI_F4_WORKSPACE
workspace sizeof(MD5STATE_T)
null_preinst ADE_2CXI_SKIP
result DB_CHR_TYPE
operands DB_VCH_TYPE
routine adu_N20_md5sum adu_B20_md5sum adu_E20_md5sum


Marty ]]> Ingres Database Contributions martymonster http://community.actian.com/forum/ingres-database-contributions/15261-aggregation-functions-begine-end-help-please.html http://community.actian.com/forum/application-development-using-openroad/15260-treeviewfield-outline.html Wed, 12 Jun 2013 08:30:25 GMT Any reason why I cannot change the outline style/colour/width of a TreeViewField? They are not available in the Property Inspector, however it... Any reason why I cannot change the outline style/colour/width of a TreeViewField?

They are not available in the Property Inspector, however it accepts the changes via the code but does not reflect the visual change on screen. ]]> Application Development using OpenROAD petew1970 http://community.actian.com/forum/application-development-using-openroad/15260-treeviewfield-outline.html http://community.actian.com/forum/application-development-using-openroad/15259-openroad-client-app-postgresql.html Tue, 11 Jun 2013 11:31:37 GMT I am wondering about any possibility to connect to PostgreSQL DB from OR 6.0 client applications?
If it's possible, please, could you give me a connection example? ]]> Application Development using OpenROAD vesna http://community.actian.com/forum/application-development-using-openroad/15259-openroad-client-app-postgresql.html http://community.actian.com/forum/vectorwise-q/15258-possible-trash-files-cbm-default-directory.html Mon, 10 Jun 2013 15:32:25 GMT Hi! Is it possible, that in the ingres/data/vectorwise/dbname/CBM/default directory exist some files, that are not corresponding to any metadata... Hi!

Is it possible, that in the ingres/data/vectorwise/dbname/CBM/default directory exist some files, that are not corresponding to any metadata managed by the current VectorWise instance? In other words: if a server crashes, receives a SIGKILL or gets an unsuccessfull upgrade, can some trash be left there? If so, is there a way to spot such files and delete them safely?

Best regards! :) ]]> nk_pl http://community.actian.com/forum/vectorwise-q/15258-possible-trash-files-cbm-default-directory.html http://community.actian.com/forum/application-development-using-openroad/15257-compiling-ascp_load_metagen.html Mon, 10 Jun 2013 10:32:17 GMT Good Morning All, I am trying to import and compile an application, made of report, procedures and so on. But it returns the following error. ... Good Morning All,

I am trying to import and compile an application, made of report, procedures and so on.

But it returns the following error.

Please have you any advice?

The error is the following:

Object start_frame fetched from ept_icd.exp.
Loading start_frame into database . . . done.
Compiling application components . . .

Compiling ascp_load_metagen . . . E_DO0043 Error including application struct_uniq.
A non-recoverable error occurred while attempting to load the included
application struct_uniq. Any references to its components by the host
application will not be able to be resolved.
Subsequent errors should give more details.

E_DO0005 The source object does not exist.


E_DO0043 Error including application struct_uniq.
A non-recoverable error occurred while attempting to load the included
application struct_uniq. Any references to its components by the host
application will not be able to be resolved.
Subsequent errors should give more details.

E_DO0005 The source object does not exist.


E_DO0043 Error including application struct_uniq.
A non-recoverable error occurred while attempting to load the included
application struct_uniq. Any references to its components by the host
application will not be able to be resolved.
Subsequent errors should give more details.

E_DO0005 The source object does not exist.


done.
ERROR: Compile errors in component ascp_load_metagen.

Have a nice Day

Aemme ]]> Application Development using OpenROAD aemme http://community.actian.com/forum/application-development-using-openroad/15257-compiling-ascp_load_metagen.html