Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 6D523632B50; Fri, 25 Jun 2010 10:57:48 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 94358-01; Fri, 25 Jun 2010 13:57:39 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-px0-f174.google.com (mail-px0-f174.google.com [209.85.212.174]) by mail.postgresql.org (Postfix) with ESMTP id 1F5E26324BE; Fri, 25 Jun 2010 10:57:40 -0300 (ADT) Received: by pxi8 with SMTP id 8so708633pxi.19 for ; Fri, 25 Jun 2010 06:57:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:subject:references:in-reply-to :content-type:content-transfer-encoding; bh=qhvWydlM2/HW2am1Nvx09wjSUGLKwhh7CV7jJL7gsNY=; b=Otqqssk/Ss11FHibclJHUoKb7G3lJMjXjvgMUSgyBGBXMt5lUND+AmzhGw5huFK5sy JZMPIZvRaUQAhdSX17DZ0pTlbk/CItABKgDNILh4V24QBtmgq/QON27UC5wE/lreakzA 8Yzr+T2/FJo24pZGiBeHHBoYTEtVxEVxWDsLc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:content-type:content-transfer-encoding; b=KeANRIxrVRh8R5Lu+Bsp7MYSGqjUFPVBa8tYT+wVmiE5L2c61qqSI1JO+P4PPBLHLQ EcPZ2j4J7iTKscwLOJ/d+dWDAQM7MATj3FMliOBiah04TlxB7kI2OxUYetPw9e3wnD92 0mFBlQ1L4HsBjrxhgr+48951cK1KGRjFVz2hk= Received: by 10.142.249.16 with SMTP id w16mr905874wfh.134.1277474258693; Fri, 25 Jun 2010 06:57:38 -0700 (PDT) Received: from [10.0.2.101] (p0245ed.tokyff01.ap.so-net.ne.jp [121.2.69.237]) by mx.google.com with ESMTPS id k17sm536420rvh.15.2010.06.25.06.57.36 (version=TLSv1/SSLv3 cipher=RC4-MD5); Fri, 25 Jun 2010 06:57:37 -0700 (PDT) Message-ID: <4C24B5D7.4040301@gmail.com> Date: Fri, 25 Jun 2010 22:57:43 +0900 From: Satoshi Nagayasu User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; ja; rv:1.9.1.10) Gecko/20100512 Thunderbird/3.0.5 MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org, pgsql-docs@postgresql.org Subject: Re: [INTERFACES] ECPG Documentation Improvement References: <4C19E5B9.3040002@gmail.com> <4C1B9735.2040505@enterprisedb.com> <20100624122325.GF24137@feivel.credativ.lan> <4C236164.6070006@gmail.com> In-Reply-To: <4C236164.6070006@gmail.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201006/79 X-Sequence-Number: 5647 Hi all, As I mentioned in the previous mail, I have almost finished writing new ECPG SQLDA section. This document is based on the current ECPG/SQLDA documents, and added some examples to help writing SQLDA code in ECPG for application developers. It has following 9 sub-sections. - Developing an ECPG application with SQLDA - SQLDA data structure - sqlda_t structure - sqlvar_t structure - struct sqlname structure - Retreiving a resultset with using an output SQLDA - Passing query parameters with using an input SQLDA - A sample application with SQLDA - Retreiving/passing values with using PostgreSQL special types The new document is available here. SQLDA.pdf http://code.google.com/p/ecpgdocs/downloads/detail?name=SQLDA.pdf&can=2&q=#makechanges I hope you to look this document, and if you're interested in ECPG and/or documentation things, please send me back your comments or advices. Any feedback would be greatly appreciated. Regards, -- NAGAYASU Satoshi