Spaces
Apps
Templates
Create
Profound Logic Documentation
All content
Space settings
Content
Results will update as you type.
•
Profound Logic - Product Support Policy
Profound AppDev
Profound UI
Profound.js
•
Profound.js Overview
Installation
Getting Started with Profound.js
Using Low Code
Profound.js Framework
Visual Designer for Profound.js
•
Strongly typed fields
Promises
•
Fibers
•
Hot module reloading
•
Error reporting and logging
•
Passing parameters to an initial module
Profound.js Connector
Profound.js Coding Reference
Profound.js API List
Array API
Call API
Data Area API
Data Conversion API
Data Structure API
Date/Time API
Declaration/Initialization API
Encryption API
Error Handling API
Information/Logging API
Number API
Memory Management API
Printer File API
Record Level Access API
SQL API
Data API
•
pjs.allocStmt()
•
pjs.bindParameters()
•
pjs.close()
•
pjs.getConnection()
•
pjs.getDB()
•
pjs.getRemoteDB()
•
pjs.escapeString()
•
pjs.execute()
•
pjs.executeDirect()
•
pjs.getSQLOption()
•
pjs.setConnectAttr()
•
pjs.query()
•
pjs.parallelQueries()
•
pjs.setSQLOption()
•
pjs.setStmtAttr()
•
pjs.prepare()
•
pjs.connect()
•
pjs.disconnect()
•
pjs.sqlHelper
•
SQL Diagnostics
SQL Examples
•
Fetch into fields
•
Fetch into primitive object
•
Multi-row fetch into data-structure array
•
Multi-row fetch into data-structure array with parameters
•
Multi-row fetch into primitive object
•
Load Rich Display Grid using SQL
•
Retrieve Auto-Generated Row Id after Insert into DB2 Table
SQL Fetch API
String API
User Interface API
Server Management API
IFS API
Miscellaneous PJS APIs
Profound.js Constants
Profound.js Directives
•
Profound.js Intellisense
Profound.js Reserved Words
•
Server-side Typescript
•
Profound.js Function Handling
•
Handling Session Ending in PJS Modules
•
Profound.js Server performance
•
Profound.js performance logging
•
File Encryption
Decimal Arithmetic
Troubleshooting
PJS tips
Profound API
Profound AI
Profound Installer
You‘re viewing this with anonymous access, so some content might be blocked.
Close
Profound Logic Documentation
/
SQL Examples
SQL Examples
Former user (Deleted)
Jessica Tomkins
Owned by
Former user (Deleted)
Last updated:
Aug 16, 2023
by
Jessica Tomkins
Loading data...
{"serverDuration": 39, "requestCorrelationId": "fd03fb71f803471ea2d6433df2be0458"}