Can we bail out DB2 list report to the record regulating the SQL statement?

Posted on August 1st, 2011 in Common Technique by admin

This is a application which can be used to bail out a list (select *) or any SQL matter to a vsam file. A representation is in ‘UIDP.PROD.JCL(JL0030DB)’

See below:

//JL0030DB JOB (001,0030,000),’BRENDA ULIN’,CLASS=O,MSGCLASS=Y

//UNCATLG EXEC PGM=IEFBR14

//UNCAT1 DD DSN=DISK.D0030.JL.ADMCFEES.DATA,

// UNIT=DISK,SPACE=(TRK,(1)),

// DISP=(MOD,DELETE,DELETE)

//UNCAT2 DD DSN=WEEKLY.&SYSUID..SQLCMDS.ADMCFEES,

// UNIT=DISK,SPACE=(TRK,(1)),

// DISP=(MOD,DELETE,DELETE)

//UNCAT3 DD DSN=WEEKLY.&SYSUID..SQLRECS.ADMCFEES,

// UNIT=DISK,SPACE=(TRK,(1)),

// DISP=(MOD,DELETE,DELETE)

//*

//UNLOAD EXEC SQLUNLOD,SYSID=DSN,SUFFIX=ADMCFEES

//SQLUNLOD.SYSIN DD *

SELECT A.ADMC_SOC_SEC#, CHAR(DECIMAL(ADMC_SEQ#,5,0)),

ADMC_AREA, ADMC_CATEGORY, CHAR(ADMC_FEE_AMOUNT),

ADMC_AMOUNT_TYPE, ADMC_ACTION, ADMC_INPUT_DATE,

ADMC_DESC, ADMC_COLLEGE, ADMC_SESSION,

ADMC_FEES_USERID

FROM ADPD004.ADMCMSTR A, ADPD004.ADMCFEES B

WHERE A.ADMC_CONTROL# = B.ADMC_CONTROL#;

/*

//* This is only to rename a dataset

//SORT1 EXEC SORT

//SORTIN DD DSN=WEEKLY.&SYSUID..SQLRECS.ADMCFEES,

// DISP=SHR

//SORTOUT DD DSN=DISK.D0030.JL.ADMCFEES.DATA,

// SPACE=(10790,(5000,10),RLSE),

// DISP=(NEW,CATLG,DELETE),UNIT=DISK,DCB=*.SORTIN

//SYSIN DD *

SORT FIELDS=COPY

END

/*


Create the chart

Posted on March 12th, 2011 in Common Technique by admin

    Select a interpretation we wish to tract [in columns, preferably]. Include their titles [ie: temperature, viscosity] if we wish them to uncover up in a legend.Make certain your columns from Left to Right have been your X as well as Y coordinates, respectively. INSERT>chart or click upon Chart Wizard. Choose a draft type. Usually X-Y Scatter. Then select a specific sort of ie: X-Y Scatter. Select air wave symbol for interpretation in rows or columns, yes or no corresponds to yours [usually columns]. TITLES tab: give your draft a title, X-axis label, Y-axis label. GRIDLINES tab: varies a gridlines upon your chart. LEGEND tab: lets we not uncover a legend, or shift a upon all sides upon a graph. DATA LABELS tab: lets we tag a interpretation points [with %values, etc.]. Select where we wish this graph to go: upon it’s own piece or embedded in a spreadsheet

Error 1335: The Cabinet record DATA.cab compulsory for this Install is Corrupt

Posted on November 17th, 2010 in Common Technique by admin

Error Message:
Error 1335: The Cabinet record DATA.cab compulsory for this Install is Corrupt. (CorelDRAW 12)
Translation:
You might embrace this summary as we try to implement CorelDRAW 12. The complaint is mostly a outcome of unwashed or shop-worn media.

Solution:
Corel’s Knowledge Base suggests 3 probable solutions to this problem. First, try to purify a designation CD regulating a soothing as well as dry cloth. If a hoop is visibly damaged, hit Corel’s patron use for a replacement.

Second, if we have an additional visual expostulate upon your computer, try installing CorelDRAW regulating a alternative drive.

Finally, we can try to run a designation from your tough drive. To do this insert a initial designation hoop of CorelDRAW twelve in to your CD-ROM drive. Next, upon your Desktop emanate a latest printed matter patrician CD12 Install. Then double-click My Computer. After that, right-click a visual expostulate containing a hoop as well as click Copy. Then tighten out of My Computer, go in to a latest CD12 Install printed matter we only combined upon your Desktop, right-click, as well as name Paste. Finally, begin a designation by double-clicking a setup.exe record which we only copied in to your CD12 Install folder. The program should beam we by a rest of CorelDRAW 12′s setup.