This article provides a technique using DBSQLPR to extract the first 80 bytes of a variable length field from a CA Datacom Table that is SQL accessible.
This is a 2 step process:
1. Use CA Datacom DBSQLPR batch utility to extract the data.
2. Use IEBGENER to copy to positions 2-81 to a new fixed 80 data set.
Details for each step:
NOTE: The CA Datacom table must be "SQL-able" in order to run SQL requests. That is, the value of the table's SQL-INTENT attribute must be "Y". "SQL-INTENT" for a tabl can be checked via a CXX report of the database.
For additional information on DBSQLPR and SET-INTENT, refer to the CA Datacom/DB SQL User Guide