Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rOWkB-004wMW-Ix for pgsql-general@arkaria.postgresql.org; Sat, 13 Jan 2024 05:39:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rOWk9-0076cx-S1 for pgsql-general@arkaria.postgresql.org; Sat, 13 Jan 2024 05:39:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rOWk9-0076co-Dl for pgsql-general@lists.postgresql.org; Sat, 13 Jan 2024 05:39:41 +0000 Received: from mail-qk1-x735.google.com ([2607:f8b0:4864:20::735]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rOWk2-001JIx-U5 for pgsql-general@postgresql.org; Sat, 13 Jan 2024 05:39:40 +0000 Received: by mail-qk1-x735.google.com with SMTP id af79cd13be357-78313f4d149so688530585a.1 for ; Fri, 12 Jan 2024 21:39:34 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1705124372; x=1705729172; darn=postgresql.org; h=content-transfer-encoding:subject:from:cc:to:content-language :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=LWySxoTAZY0aZ6kkw/CA87915kXmZgQuBl39MN2l33M=; b=P+b/aqlNRbor53yU3dvzMjg8QN8BW+02Jcxk5REr+ot0dHckyZx5WNtOKDjq0A5A1b g7Tfegm5e8vCupkwMmc6BV+8qypya+xHhVf7Ty5c7Pr3M7z+A/qTOXKplomW1Myxbw3b rRlnVcsyE16P/fz9kHVJFYkS0Yd/Y47lBANYfnSmavvpII6ocWN5WZuixopENDGBWb6L qwzywQZ0Gy3HsuMjgAiW8DU7viY1mnPXmUfHZ4wBfwbmljNKGjzPJONMuNjLD1ICT7hF ZrPO8hbKSY5SmqnSgXTej+a8UKg+w4UkczgM+AWv1SVsK1iaq4DIiGrlgY4snf8JO49S lvyA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1705124372; x=1705729172; h=content-transfer-encoding:subject:from:cc:to:content-language :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=LWySxoTAZY0aZ6kkw/CA87915kXmZgQuBl39MN2l33M=; b=U8P3S05tYv/Yk/K6fuiBANP8c3xye3Ul0FoEWZHCcqQxULUj8yGD8syhAg/skEuxTD 0ABaingebXHp+ZkjZwsPEqyuuepFzy7Rpe5jzGCc+t4m6AiO9ym6X3JMP5z8TT55/W4t EqRcXG6BsPecWRzlFs07NZlF9gemExtedFEdfOe2fGyJMYAWWd1zxkDERPS1VmweMKWo K0B/t/bMG25OIr1MTNBExW2EVAe2G/Hmt6qWH5EP7gu6vjnqJxh6QDLUj/mcKAQSibRV LnzEb2MVzKHbg0pK/2Ak11nnA9RpQj1SNA8Dyp7m87s3zN6W2DFGc8Jvc+CC2otnu88k JeFg== X-Gm-Message-State: AOJu0YyWi5tyYPDO8ZiuKBs5vkAt9hNToTN2Y/2cgRH5mk8t0R+NW9N7 hFYrGNY/oRmyR5WLg6H06nr4knzrvT4= X-Google-Smtp-Source: AGHT+IFM3xdMpdTjasYGg3+hxyMKleXQFwQR9qjBuBJqSN0bQ+CccDEO7qdegUF9W+QtxQ6uiY9lmw== X-Received: by 2002:a05:620a:102a:b0:783:1939:ada with SMTP id a10-20020a05620a102a00b0078319390adamr2939233qkk.116.1705124372024; Fri, 12 Jan 2024 21:39:32 -0800 (PST) Received: from [192.168.1.101] ([172.56.10.252]) by smtp.gmail.com with ESMTPSA id de28-20020a05620a371c00b00783395ce1d5sm1525626qkb.136.2024.01.12.21.39.30 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 12 Jan 2024 21:39:31 -0800 (PST) Message-ID: Date: Fri, 12 Jan 2024 23:39:30 -0600 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Content-Language: en-US To: pgsql-general@postgresql.org Cc: Simon Sobisch From: Chuck Haatvedt Subject: COBOL PRECOMPILER for PostGreSQL Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello,

I'm working with the opensource GNUCOBOL project. One of our efforts is to provide a migration path for organizations to move from commercial COBOL compilers to GNUCOBOL. One of the impediments to this migration is to move from an Oracle or IBM RDBMS solution to PostGreSQL. Most organizations are using one of these RDBMS solutions with COBOL precompilers supplied by the vendor and have embedded SQL in their source code. This represents a significant challenge to any migration as there is not a COBOL precompiler for PostGreSQL.

I would like to propose that the ECPG precompiler for C, to be modified to accept either C or COBOL. Another option would be to clone ECPG to work with the COBOL language. For the most of the COBOL variable types it should not be too difficult to convert them to C variables which would reduce the effort. Both of these RDBMS use the syntax similar to C, EXEC SQL ..... END-EXEC, where text between them is the actual SQL statement or variables.

        Thanks for your consideration,
--

Chuck Haatvedt

chuck.haatvedt@gmail.com