Questions and answers
APPX FAQ
From faq.appx.com
20 chapters, 466 topics
Answers to questions people asked about APPX, with their words as written. Some of them describe older releases; the manuals have the details for current releases. People's email addresses are left out: for help today, use Support at the top of the page.
-
ILF (Integrated Language Facility)
- 0Is the documentation for the CNV TEXT statement wrong regarding the use of occurrence "000"?
- 0How do I get the my current APPX Process ID
- 0ILF verb shortcuts (abbreviations).
- 0GOSUB/SUBR/COPY exit considerations.
- 0GOSUB/COPY/SUBR usage considerations?
- 0Variable Scoping considerations with GOSUB/COPY and SUBR.
- 0Load time, memory usage, and caching considerations when determining using GOSUB, COPY and SUBR.
- 0Why are there lowercase I/O Verbs in ILF?
- 0ILF Option 94
- 0ILF Force Save Option 88
- 0ILF Option 95
- 0Text and Icon Position via ILF --- WIDGETs
- 0How can my APPX process tell if a user is running the GUI client?
- 0What is pdf "---ENTRY SELECTED PATH" used for?
- 0What does scope refer to?
- 0What is the scope of a work field?
- 0How to get User Security Codes using ILF.
- 0How to get the name of the Parent Process.
- 0Example of a random number generator using ILF!
- 0How to retrieve an occurrence number with ILF!
- 0Use of --- DEFAULT MODE
- 0How to determine a leap year!
- 0How does LOCAL and RECEIVE statements work?
- 0I have set my --- OPTION = END PARAGRAPH, but it doesn't seem to do anything. Why is that?
- 0I am trying to PASTE a statement into the ILF editor, but it put "**" in the front of it and it looks miss-aligned. What did i do wrong?
- 0The --- COMPARE file contains the fields that are different after an IF DIFF is executed. If a field has multiple occurances, how can I tell which occurance changed?
- 0Can I change the key of a file while in a BEG / END READ loop?
- 0I am trying to do a BEG READ/END READ, which nests a BEG READ/END READ on the same file
- 0Does APPX has something equivalent to WHERE LIKE "%123&"?
- 0What is the difference between --- MODE and --- INTERACTIVE PHASE?
- 0How can i tell from the ILF code what screen size user has?
- 0Which Windows version are we?
-
Input Processes
- 0How can I scale a picture on an Input screen?
- 0How to add a second image to a frame in an input process
- 0Message “Scrolling Frame Must Precede All Interactive Frames”
- 0How to have a scrolling input process display in-progress messages?
- 0Display spaces instead of MM/DD/CCYY on an input screen which is inquiry only
- 0Can my scrolling input refresh itself when a record is added or deleted?
- 0Can I use different image sizes in my scrolling input?
- 0How do I create a dynamically sized scrolling input?
- 0When using the PICTURE command I get Load Error!
- 0How to set button (widget) colors!
- 0How to print tech doc for GUI input processes?
- 0How to get information about why the --- SEND FILE TO CLIENT subroutine failed?
- 0How can I dynamically apply Special Characteristics (Underline, Bold, Inverse Video)
- 0What’s PreDisplay/Verify for?
- 0How to display the HELP text for the current Menu?
- 0How do you create dynamic screen titlebar text with ILF?
- 0What are the rules for non-positive widget positions within an image?
- 0How do I stop APPX from automatically displaying the next record during INQUIRY.
- 0How can I make a constrained field editable?
- 0Which fields in the --- WIDGET file correspond to the GUI attr. input fields?
- 0When I go into an Input screen with Optional Children exceeding option number 130 - options 1 through 30 are not there.
- 0Word wrapping on multi-line text fields.
- 0Is it possible to make the cursor on APPX thicker or more visible?
- 0How to blank out or make invisible a Field on an Image
- 0Optional frame may result in infinite loop
- 0How To Add a Picture to an input process
- 0Is it possible to suppress the binoculars on a field that has a DLU defined?
- 0How to refresh parent screen after a child process.
- 0How can I run a constrained input process via ILF?
- 0How to QUERY/INPUT via Cache!
- 0How to display detailed data from a scrolling input.
- 0Is there a way to set child constraints on a data lookup field in an Input Process?
- 0How can i set default values during data entry and make Appx remember them from one entry to the next one?
- 0Will a automatic child process run if auto update is set to "Y", even if include children = No
- 0How do you turn off dynamic indexing in APPX?
- 0What is dynamic indexing?
-
Output Processes and PDF
- 0How do I keep an Output from automatically printing Grand Totals?
- 0Can I print a date in Julian format?
- 0When I add rows at the frame level the rows on the image do not change.
- 0Does APPX support printing a bar code on an output form?
- 0How to get a setup grid on a PDF report?
- 0How to format a date to automatically display day of week or month of year!
- 0Can I format the date on automatic OUTPUT header(s)?
- 0Why are my labels in an output PDF report being truncated?
- 0How do I pass 'ESCape' sequences to my printer?
- 0How to print duplex, print on front and back of each page
- 0How to program an exception report, example of ALTERNATE IMAGE NUMBER
- 0Can GRAND TOTAL be controlled via ILF
- 0Additional help on PDF layout options
- 0Now that I can generate PDF files from APPX, how can I get the PDF to display as such in a browser?
- 0What is the best format to print a logo, images?
- 0We need to be able to use a specific font to support an OCR scan line
- 0HTML tags that can be used within a text field that is to be displayed with an HTML Viewer widget type via the APPX client.
- 0Can I print an OCR font in a PDF document?
- 0How to embed an image on an output?
- 0I have upgraded to 4.2.6 recently and now my PDF output text is shifted
- 0Is there a limit to the number of lines PAGE-END can have?
- 0HTML in PDF Documents
- 0How to create a PDF Form Overlay.
- 0Why don’t icons print in tech doc?
- 0What image file formats are supported in PDF documents created within APPX?
- 0Debugging PDF Output Problems
-
Query, Update, Job and Subroutine Processes
- 0Query stops before processing entire file!
- 0Why doesn’t my QUERY use the file’s index?
- 0Can I create a Cached copy of a file to use in my pre-user selection event point?
- 0Is there a way to edit query and sort order screens?
- 0How can I show my users a progress message?
- 0How to change the Progress bar color during an update!
- 0How can I get a date range from an input to the heading on an output?
- 0Invocation error when subroutines with the same name in different applications
- 0I have a subroutine in an application and I am trying to hook it to a different one and it does not work
- 0Previous Activity key
-
Data Dictionary, Files and Event Points
- 0How many fields can be defined for a file in the Data Dictionary?
- 0I changed the alignment of the field from left to right but the sorting remains the same, why?
- 0Can I invoke another process in a FLEP?
- 0FLEP’s may not execute when the cache priority it set to 1.
- 0What is the scope of a FLEP?
- 0Can I pass information into a FLEP?
- 0How many times does Post-PCF Read FLEP fire?
- 0Do many duplicate keys decrease the performance?
- 0Can ERROR statement be used in FLEP's?
- 0FLEP questions
- 0I want to delete fields from a file in my DD, but those fields contain data, should i delete the data first?
- 0I added a new value to a validation table and it’s not listed at run-time, why?
- 0Is it possible to get APPX to automatically convert Gregorian date fields to Julian dates?
- 0How to determine IO mode (READ,WRITE,HOLD) within a FLEP
- 0Scope of cached files!
- 0How data sharing is accomplished in APPX!
- 0What is the difference between file content and file stream?
- 0How to make a negative sign appear in front of the number (instead of behind)
- 0How do you copy from one application database to another within APPX.
- 0What is the correct Date Mask for: Apr 13 09:23:00 2004?
- 0Copying Files between Databases/Versions
- 0Adding new fileds with defualt values to an existent file
- 0I have an ALPHA field with a validation table, but it allows for any value to be entered, regardless of the validation table values
- 0Execution Cycle in Appx 4.2
- 0What is an event point?
- 0How does the pivot year logic work?
- 0File-Level Event Point Modes
- 0Has APPX ever considered to introducing field level event points?
- 0Can I tell which event point I am in for appropriate processing my a generalized subroutine?
- 0Is possible to read the design files 0AD PROCESS, 0AD CHILD, 0AD WIDGET etc. of the current application?
- 0What is standard APPX data record wrapper?
- 0Is there a PDF for the record number in a consecutive file?
- 0How to set APPX_PIVOT_YEAR?
-
GUI: Widgets, Pictures and Menus
- 0How to create dynamic rollover tool-tips.
- 0How to play sounds.
- 0How do you create a vertical or horizontal line on an input image?
- 0GUI themes via ILF!
- 0How can I position a widget exactly where I want it?
- 0Can we colorize the "auto gui" widgets by ILF in order to adapt them to color schemes?
- 0How to put multiple of lines of text on a button or label widget.
- 0How to add pulldown menu entries with ILF
- 0The underline character is not displayed under the shortcut letter!
- 0Is there a way to get rid of the automatic drop down menus that appear on my GUI menus processes?
- 0Is there a way to get rid of the big red X (Cancel) and the green arrow (Return)?
- 0I keep loosing my toolbar when I go in and out of the Image Editor.
- 0Can a button with a picture be resized using APPX software alone?
- 0Where do digital image files reside?
- 0Where do we get digital images from?
- 0What is "Point Size"?
- 0Can we create widgets at run time dynamically?
- 0How do I change widget properties on a hooked 0LC DISPOSITION screen.
- 0Is there an existing utility to list Named Resources?
- 0I am trying to change my named resource for wallpaper, but all i am getting is a small image in the corner instead
- 0What does the * after the Chg on the status line mean?
- 0Graphic resource(s) not being displays (red X)?
- 0How to turn off full selection (highlighted) of text fields in change mode.
- 0Is there any "standard" screen size as it relates to the GUI interface?
-
Files, Streams and Other Software
- 0How do I send a file to a client PC and open the file with a client side App? (i.e. Excel)
- 0How can I import consecutive (flat) files into APPX?
- 0Checking return code after a Stream Write.
- 0How to close an external ASCII file (RT_CLOSE_STREAM)?
- 0How to read data to an external ASCII file (RT_READ_STREAM)?
- 0How to write data to an external ASCII file (RT_WRITE_STREAM)?
- 0How to open an external ASCII file (RT_OPEN_STREAM)?
- 0Dynamic linking using the CALL statement.
- 0How do you run an os command and pipe the results through a stream read?
- 0How can I wait on Windows-systems without consuming CPU?
- 0I am using a --- STREAM WRITE call on a file that is > 2GB. It doesn't crash or return an error code, but it doesn't write to a file either
- 0When I execute SLEEP command from an Appx CALL i get the error 'You've CALL'ed C:\WINDOWS\SYSTEM32\kernel32.dll,Sleep with the wrong calling convention'
- 0What is the proper usage of --- STREAM READ LENGTH field?
- 0Can the STREAM READ look for the presence of the \r character as a record delimeter?
- 0How to create an ASCII fixed length flat file using Appx
- 0What should the field "CDF Path & File" on the Comma Delimited Update screen contain?
- 0Diagnose SUBR --- SEND FILE TO CLIENT problems
- 0More information about why the --- SEND FILE TO CLIENT subroutine failed?
- 0Several commands which I can RUN successfully on our HP-UX 11.0 system, do not work when invoked on a Redhat Linux 9 system.
- 0Memory corruption after calling an external subroutine.
- 0How do we use the routine --- READ FROM CLIENT CLIPBOARD?
-
Other Design Questions
- 0Commonly used APPX Abbreviations
- 0Are there reserved words in APPX?
- 0ILF Statements missing on the cross reference selection screen!
- 0What is the 0LC application?
- 0Direct process doesn’t work, causes system internal error. The process works okay when I option 99 in design mode.
- 0How to see a trace of executed process
- 0What kind of code does APPX generate?
- 0What are the zero apps?
-
Messages and Errors
- 0Message; "op_prt_buf, print new page fa".
- 0Message; “free_pool() - attempting to free unallocated memory ()”
- 0Message; “Internal Error has Occurred, Proceed with Caution”
- 0Message; "Cannot write any more qdaemon"
- 0Message "memcpy - trash the heap"
- 0Message; "unknown AppxIO status"
- 0Message; "Can't connect to host"
- 0Message; “PDF_begin_page: Function must not be called in ‘page’ scope”
- 0Message; “Connection Refused by Host”
- 0Message; “Application Lock verification failed. Access Denied”.
- 0Message; “can't write cwdgt - Error - Already on File”
- 0Message; “Cannot read cfi_rec”
- 0Message: “mm_free() 'freeing watched address' or 'attempting to free freed memory'"
- 0Message; "pl rloc - too few cchld records(1)"
- 0Message; “ID not defined as valid Login”
- 0Message; “File Organization Specification Mismatch”
- 0Message; “License Server not Detected”
- 0Message; "file does not exist"
- 0Message; "Can't connect to Host" or "Connection refused by host" (Troubleshooting WinAppxD)
- 0Message; "Allocation of TOKEN_USER failed"
- 0Message; "LookupAccountSid() failed"
- 0Message; "can't open stream socket"
- 0Message; "can't bind local address"
- 0Message; "op_prt_buf, print new page failed"
- 0Message; “There was an error opening this document. No such file or directory”
- 0NET_LOG 'error's 122 & 10054
- 0PDF Output: "Windows cannot find $display"
- 0Message: "required data was not placed into memory because of an I/O error"
- 0Message – “Error - Invalid Request Using Main ARB”
- 0Message "Found active record on freelist"
- 0Message. "ERROR - CANNOT ACCESS REQUIRED FILE"
- 0What does error "Can't read LFN File - Error - Already on File" mean?
- 0Message, "can't empty sarb list"
- 0Message, "bad reg no."
- 0Message "An unexpected error occurred, please enable logging and retry"
- 0Message "Cannot write to Cache - Invalid Prototype Record Length"
- 0Message; "No Record Currently Held"
- 0Message, Error - Request Not Allowed
- 0Message, "BI.C - APPX Startup Failure: Unable to Initialize Window Manager"
- 0Message: "key field conversion failure - Error - Invalid Logical Value"
- 0Message; "too much data"
- 0Message, "Network IO Error"
- 0Message, "ORA-01000: maximum open cursors exceeded"
- 0I am trying to start appx from a DOS command line and getting BI.C error
- 0Message "pc_item - Unexpected case switch"
- 0What does error "Appx startup failed because of the following startup error: 34" mean?
- 0What does "Corrupt lfb list" C-Assert mean?
- 0Message: "Building Dynamic Index"
- 0Message, “Can't access named resources”!
- 0Message; “Invalid Native File Management System”
- 0"mm free()-corrupted trailer"
- 0"bad portable file - non-blank character found between portable fields"
- 0What does error message "Missing or invalid process definition record, 0LA subroutine SESSION (BEGIN)" mean?
-
Using APPX and the Client
- 0What is the difference between END and CANCEL?
- 0Is there anyway to force the appx client to open in a specific size window?
- 0What does the check mark on the Java client do?
- 0Pasting data into a text field in APPX.
- 0How do you set up keystroke playback (keyboard scripting)?
- 0No Beep on Errors and Warnings
- 0Am I running Java Client?
- 0What's "appx.exe -f=" mean?
- 0APPX/Client startup problems
- 0Slow APPX Login Time
- 0Auto-update Java Client version
- 0Appx/Client timeout duration
- 0Appx-Client scrambled display on Startup Login
- 0Is there any way to increase the screen response time using the APPX client.
- 0Diagnosing Appx/Client problems
- 0Home
- 0How to display high ASCII characters.
- 0I noticed that all of a sudden i have Applications tab on my Java client. How did it get there and how to get rid of it?
- 0Recording Macros on Unix
- 0Print Setup on the Java Client
- 0Where is Java/Client cache?
- 0How do I setup an APPX/NET client?
- 0I am trying to connect to the APPX Demo server but get the message "Connection refused by host".
- 0I have Appx/Net going, but unable to scratch a file from the client side. Should i be able to?
- 0When i try to login to Appx from my HP Notebook, i get an error "Negotitating GUI Interface" and it hangs
-
Performance and Troubleshooting
- 0Why is APPX building the EM’s every time?
- 0Can I get a log of file activity using APPXIO?
- 0How do you diagnose strange or generic errors (such as bus errors, seg faults, attempting to free freed memory errors, or "an internal error has been detected" errors)?
- 0How do I see the APPX Process Stack?
- 0What is the APPX Process Stack?
- 0How do you turn on/off AppxDSvc logging?
- 0Is there an environment variable that records a log of the user interface?
- 0How can I produce an Appx Event Log?
- 0Is Appx a multi-threaded Application? WIll it take advantage of multiple CPUs?
- 0Help in debugging AppxIO
- 0Scan hangs!
- 0Action Logs don't generate
- 0Performance Issues
-
Installation, Upgrades and Licensing
- 0How do I determine the CPU serial number on Linux platforms?
- 0How do I determine the CPU serial number on Unix platforms?
- 0How do I determine the CPU serial number on Windows platforms?
- 0What operating system versions are required to run APPX?
- 0Which TCP/IP ports are used by APPX?
- 0How do I upgrade APPX 3.5 or 4.0 to version 4.1?
- 0Where does APPX create temporary disk files?
- 0How to set up License Servers under Novell thick client.
- 0What is “xtra-gui”?
- 0Can I install APPX to a mapped drive?
- 0If the base 'Data' directory is immediately under the appx engine (as it almost always is), does anyone know of any reason one would want to use APPXPATH?
- 0After an upgrade of the system from 4.1.a to 4.2.3 there is no 0LC application. What's missing?
- 0I am preparing to upgrade to 4.2. The installation instructions suggest that I copy the License Key file so it can be imported in the version.
- 0Setting HP-UX Kernel parameters
- 0Recommended system configuration for running APPX.
- 0Exporting and importing design files on different platforms.
- 0Emergency Registration for Supported Customers
- 0How to install Appx on a Cluster
- 0How to convert an HFS or Vxfs filesystem from a nolargefiles system to a largefiles system
- 0What is the environment variable for identifying the Ethernet adapter for the APPX serial number?
- 0How do I upgrade APPX 3.5 or 4.0 to version 4.2?
- 0How to manually install Appx on Linux?
- 0Checking the APPX registration number.
- 0Does APPX run on Mac OS X Server?
- 0Appx and new Daylight Savings time
- 0Can I run different releases of APPX on the same server?
- 0How APPX License counts WS's
- 0How do I start the license server?
- 0How to debug the license server
- 0How do I determine my server’s serial number required for registration with APPX?
- 0What software do I need on the data server in addition to APPX?
- 0What kind of machines and network do I need for server and clients?
- 0Are there any issues with HPUX 11.11 that we need to be concerned about?
- 0Can I export a registration key?
-
Users, Logins and Security
- 0Appx Client/Server security considerations
- 0What are required Windows rights for Appx ?
- 0What are required UNIX permissions for Appx 4.2.4?
- 0How do I keep production applications from accidentally being changed?
- 0How can I read the USER list?
- 0Can Current Release of Appx support LDAP?
- 0Is there a way to pass login nformation to APPX?
- 0Is the date/time a user signs in and out of APPX kept?
- 0What is a security profile?
- 0Getting 'ps -ef' original UserID in Linux
- 0In NT 4.0 I have a user named joe@my-company and when I upgrade the os to Win 2K Joe can’t logon. Why?
-
Windows Servers: WinAppxD and Sessions
- 0APPX.EXE process is consuming 95%
- 0The command-line "kill" too time-consuming and error-prone. Is there a better alternative?
- 0How can I determine which APPX.EXE processes on my server are orphans?
- 0All of my users except for one have gone home for the night, and I am sure they have turned off their PC's. I still see three (or four, or ten) APPX.EXE processes in the server's task list. Why are they there?
- 0A user just called me to say that her APPX Client window just disappeared, or there was a power outage or system malfunction, that caused their APPX Client session to end unexpectedly. Do I need to do anything?
- 0How do I manually kill an APPX server process?
- 0The user process is hung, and I haven't been able to resolve the problem, so I need to kill that client/server session. How do I do that?
- 0What should I do when a users APPX session is hung?
- 0What can I do if WinAppxD gets stuck regularly?
- 0When might I want to stop and restart WinAppxD (either with, or without, a reboot)?
- 0Is it safe to stop WinAppxD, if I'm going to need to restart it again without rebooting my server?
- 0How do I stop WinAppxD?
- 0How do I start WinAppxD?
- 0How can I verify that WinAppxD is running?
- 0What is WinAppxD, and what is it used for?
- 0WinAppxD service is not running (Troubleshooting WinAppxD)
- 0Client login issues - Incorrect login (Troubleshooting WinAppxD)
- 0HASP not seen by APPX (Troubleshooting WinAppxD)
- 0Getting an APPX Stack Trace / Disabling Dr. Watson (Troubleshooting WinAppxD)
- 0Excessive CPU utilization when client reboot’s PC.
- 0TCP Keep-alive registry entries
- 0Orphan Session Detection and possible causes
- 0What software do I need on the client PC in addition to APPX running the WinAppxD Daemon?
- 0Where at Microsoft are the instructions for that NT registry patch we need for installing WinAppxD?
- 0What special rights must be assigned to the account used to run the WinAppxD process?
- 0What do we need to do differently if installing WinAppxD on an NT 'member server' instead of on a PDC or BDC?
- 0I installed WinAppxD for the first time, and it isn't working, what now?
- 0How do I run two versions of WinAppxD in parallel?
- 0What environment variables must be set on the server?
- 0When installing APPX clients using WinAppxD, what do I need to know about the server?
- 0Can I keep the APPX client .exe file on a server and launch it from across the network on my clients?
- 0What if my network includes more than one Windows NT domain?
- 0What special rights must be assigned to the user accounts which will access APPX via the GUI client, Java client or AppxODBC?
- 0What APPX-provided files are needed on client PC's?
-
Printing
- 0How to reprint a print file?
- 0Printing to a printer produces blank pages.
- 0What is the relationship between winprint.exe and winprintdll.dll?
- 0How to associate PDF output to enable printing in a windows environment.
- 0Winprint won't print to my printer (Troubleshooting WinAppxD)
- 0Winprint won't print to printers that are not defined on my NT server (Troubleshooting WinAppxD)
- 0How do I print a query log?
- 0Winprint won't print to all or some of my printers. Help?
- 0Print files truncated
- 0Is the 'mpage' program required to print text files from the 4.2.4 client?
- 0I just installed Appx 4.2.4 On SunOS 5.8 and have a problem with printing
- 0What is the maximum size of a report?
-
Files and Data: Checking, Recovery and Locks
- 0How to track “Record Held by Another User"
- 0How to use recover.exe!
- 0Can I reserve an application lock?
- 0File fragmentation.
- 0How do I verify all files in a database?
- 0How do I verify the file 'ORDER' in application 'AAA', database 'DDD'?
- 0How can APPX data file indexes become corrupt?
- 0When might I want to use APPXUTIL to check my file system?
- 0Where do I get APPXUTIL?
- 0Why does a user of APPX for Windows need APPXUTIL?
- 0What is APPXUTIL?
- 0What does it mean to 'verify' a data file?
- 0How do I script imports for windows using APPXUTIL?
- 0"Recover"ing data into a consecutive file.
- 0Is it safe to remove USAGE.dat and USAGE.key files?
- 0When do entries in USAGE.dat file gets removed?
- 0How can i build up the FMS path for APPXIO data files?
- 0How to get a list of the files in which your Appx session holds record locks?
- 0Merge and Replace application data files with the Database Management Import utility.
- 0What are the maximum file size(s) in APPX?
- 0How to determining who has a file open (Unix OS).
- 0How to recover from record "locked".
- 0How are usage locks allocated?
- 0I can get the PID number from the usage file, but where can I get the port number?
-
Oracle, SQL Server and Other Databases
- 0What rule does APPX / Oracle interface use to decide when a field will be "char" vs "varchar".
- 0Oracle import performance issues.
- 0How to import dates from APPX to Oracle.
- 0Why is my RDBMS import so slow?
- 0Cannot see the Oracle database?
- 0--- COMMIT MODE PDF hierarchy!
- 0How to incorporate COMMIT & ROLLBACK into APPX code!
- 0Commit parameter doesn’t seem to work?
- 0Oracle-Store blanks, not NULL !
- 0Importing big Oracle tables!
- 0Storing zero numeric values in SQL Server
- 0I can't connect to a second instance of the database (Sybase, Oracle, etc.)
- 0Is there a way to synchronize databases in APPXIO with databases kept in SQL Server?
- 0Can we update records in APPXIO files using SQL Statements from SQL Server?
- 0French Characters in Oracle
- 0I want to use Appx with SQL Server. Are there any known issues/performance issues?
- 0How can I move APPX data stored in an FMS group to SQLServer?
- 0Is the proxy database id "LOK:" still required when using SQLServer?
- 0Do record locks display when files are in RDBMS?
- 0Oracle 9i Performance issues
- 0I have an existent RDBMS table and i want to use Field Override feature in the FMS group settings, can i do that?
- 0Accessing 2 different schema's defined for 1 instance of Oracle
- 0What is the default field mapping for RDBMS?
- 0Known issue with SQL Server SP4
- 0Storing NULL/blank values in SQL files
- 0A Handy list of RDBMS commands for various RDBMS's
- 0Why is my sqlcmd log is truncated? In prior versions, I've seen logs with create table lines in excess of 3000 char?
- 0Oracle Instant Client and Appx
- 0How to set the APPX_SQL_CMD to obtain a log of RDBMS activity.
- 0How to read the APPX_SQL_CMD Log
- 0How to set the APPX_DBG_CODE to log specific RDBMS activity
- 0Which external DB still require the proxy database id "LOK" to be set?
- 0Connect to 2 Oracle instances simultaneously?
- 0Under what circumstances you need to set NLS_LENGTH_SEMANTICS
- 0Performance issues when using a RDBMS
- 0How to connect Appx to Oracle
- 0I am trying to import a file to Oracle, but getting an error "File doesn't exist".
- 0What does Error message "Can't load Oracle dll (oci.dll)" mean?
-
APPX/ODBC
- 0WinSQL: APPX ODBC debug utility.
- 0What is my AppxODBC version?
- 0AppxODBC & Appx Security
- 0What different configurations of APPX/ODBC are supported?
- 0With APPX ODBC, files stored on the RS/6000 in APPXIO format, accessing the files from a PC using ODBC on the PC with a client like Access, what security is available? Can I use APPX internal security to control what databases/files/records/fields can be "seen" by the ODBC client?
- 0Is it possible to create Indexes in the Dharma tables to improve speed? If yes then how?
- 0Is it possible to use specific names for the FIELDS in the Dharma Tables?
- 0Are there any tweaks to improve performance when retrieving data using the Dharma ODBC link?
- 0Is it possible to change the field names that are used by APPX/ODBC?
- 0Our developers wants to know if Appx has Dharma JDBC Driver?
- 0General AppxODBC recovery
- 0Asql Errors
- 0How to uninstall AppxODBC.
-
Environment Variables and the Command Line
- 0What are the command line options?
- 0How to determine what are my environment variable are?
- 0Would adding "-session" to a command line cause APPX to respond to any input screens with an END?
- 0What does -session flag do when added to a command line?
- 0How to build a UNIX script to run an APPX process (cron job).
- 0Can I change the date and time APPX uses for testing date/time sensitive applications?
- 0Can i have environment variable APPX_41_EPS set while designing in 4.2?
- 0What are the APPX invocation switches?
- 0What is APPX_OLD_MODES variable for?
- 0Is there a work around or environment variable that suppresses the "keep key" behavior?
-
Reportwriter
- 0What is APPX Report Writer?
- 0Who can benefit from using APPX Report Writer?
- 0How do I get started using APPX Report Writer?
- 0Is a design license needed to use APPX Report Writer?
- 0Do I need to know how to design a report in APPX to use the Report Writer?
- 0Can I store my reports with my other applications?
- 0Can I access all my applications from one copy of APPX Report Writer?
- 0What type of training will a user need?
- 0Using the Export feature of Appx Report Writer.