Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Appending string to z30-barcode for a particular set of ADM numbers

    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    I have a list of 1,000 ADM sys numbers and I would like to append the string "-XVU" to the current z30_barcode. There is only a single item attached to each to each ADM record. What SQL statement would do this?

    You would need to import these ADM numbers into an Oracle table (defined in ABC50). This is described in the document "Importing p_ret_01 output into SQL" in the How To folder on the Doc Portal.

    You can skip the "p_ret_01" section; start with "Defining temporary sql file".

    Then you would use the table ("tempadmnumrec") consisting of one column "admkey") like this:

    update z30 set z30_barcode = rtrim (z30_barcode) || '-XVU' where substr(z30.z30_rec_key,1,9) in (select admkey from tempadmnumrec);

    Be sure to back up the z30 table with p_file_03 before doing this. Contact Jerry Specht with any question.

    • Article last edited: 10/8/2013