Code: |
SELECT CHAR('EXPORT QUERY ') ,CHAR(OWNER,8) || CHAR('.') || CHAR(NAME,8) ,CHAR( ' TO ') ,CHAR( '''') ,CHAR('tid.QMF.QUERIES(') ,CHAR(NAME,8) ,CHAR(')') ,CHAR('''') FROM Q.QUERY_LIST WHERE OWNER = 'your id' ; |
andrea wrote: |
I have the same problem, but I start from DB2 v6.1, without
Q.QUERY_LIST. Is there any way to save thenth of QMF objects without reformatting them because of how data are stored in OBJECT_DATA? Thanks in advance, Andrea |
Code: |
Code SELECT * FROM Q.OBJECT_DIRECTORY WHERE OWNER = 'your T-id' or SELECT * FROM Q.OBJECT_DATA WHERE OWNER = 'your T-id' |
Code: |
NAME CREATOR TYPE
------------------ -------- ---- COMMAND_SYNONYMS Q T DSQ_RESERVED Q T ERROR_LOG Q T OBJECT_DATA Q T OBJECT_DIRECTORY Q T OBJECT_REMARKS Q T PROFILES Q T RESOURCE_TABLE Q T DSQEC_ALIASES Q V DSQEC_COLS_LDB2 Q V DSQEC_COLS_RDB2 Q V DSQEC_QMFOBJS Q V DSQEC_TABS_LDB2 Q V DSQEC_TABS_RDB2 Q V RESOURCE_VIEW Q V |
kolusu wrote: |
andrea,
Did you try to use the query shown in post 2 but use Q.OBJECT_DATA table instead of Q.QUERY_LIST and see if you can export the queries? The column APPLDATA in the table Q.OBJECT data has your query and the column SEQ shows the line number in the SQL query. |
Code: |
SELECT CHAR('EXPORT QUERY ') ,STRIP(CHAR(OWNER , 8)) !! CHAR('.') !! CHAR(NAME , 8) ,CHAR( ' TO ') ,CHAR( '''') !! STRIP( CHAR('C60482.QMF.QUERIES(') !! CHAR(NAME , 8) ) !! CHAR(')') !! CHAR('''') FROM Q.OBJECT_DATA WHERE OWNER = 'id_I_need' ; |
andrea wrote: |
I only need a way to export queries with long name or with underscores in their name, but the most of the work is done. |
Code: |
SELECT CHAR('EXPORT QUERY ') ,STRIP(CHAR(OWNER , 8)) || CHAR('.') || STRIP(CHAR(NAME,12)) ,CHAR( ' TO ') ,CHAR( '''') || STRIP(CHAR('C60482.QMF.QUERIES(') || CASE WHEN LENGTH(NAME) > 8 OR NAME LIKE '%_%' THEN CHAR(REPLACE(SUBSTR(NAME,1,9),'_','')) ELSE CHAR(NAME , 8) END) || CHAR(')') || CHAR('''') FROM Q.OBJECT_DATA WHERE OWNER = 'id_I_need' AND SEQ = 1 AND (LENGTH(NAME) > 8 OR NAME LIKE '%_%') ; |
output generated using printer-friendly topic mod. All times are GMT - 5 Hours