1 PROC SQL NOPRINT;
2 EXECUTE(SET CURRENT DEGREE = 'ANY') BY DB2;
DB2 NOTE: The QUERYNO for the EXPLAIN is 7113174
3 CREATE VIEW WORK.PRICFI (CIC_ZN,CIC_MDL,CCC,FAMILY,NEW_CCY,
4 CIC_PREM,CIC_PREM_UNRND,GRP_CD,STRT_DT,STOP_DT,
5 TTM_ADD_PREM,PRT_MRK_UP) AS
6 SELECT * FROM CONNECTION TO DB2
7 (SELECT CIC_ZN,CIC_MDL,CVRG_CD,BIC_FAM,NEW_CCY,CIC_PREM,
8 CIC_PREM_UNRND,GRP_CD,STRT_DT,STOP_DT,TTM_ADD_PREM, PRT_MRK_UP
9 FROM Z1Q1.Z1AD001$.NEW_CUR_PRC
10 WHERE CIC_ZN = 'APDZONE1'
11 AND NEW_GOVT = 'NONGOVERNMENT'
12 AND CVG_TYP = 'POWERTRAIN + HYDRAULICS'
13 AND NEW_MO IN ('36')
14 AND PRT_MRK_UP = '25'
15 AND NEW_HR = 1000
16 AND CIC_MDL= '302'
17 AND STRT_DT= '2024-01-01'
18 FOR READ ONLY WITH UR);
12 THE SAS SYSTEM 11:19 THURSDAY, JULY 11, 202
NOTE: SQL VIEW WORK.PRICFI HAS BEEN DEFINED.
19 QUIT;
NOTE: THE PROCEDURE SQL USED 0.01 CPU SECONDS.
20 %SSCFLAT(MSASDS=WORK.PRICFI,MPREFIX=USER1.PG34.);
***** SSCFLAT VER 1.06
***** COPYRIGHT (C) 1999 SYSTEMS SEMINAR CONSULTANTS
***** 608 278-9964
NOTE: CONDITIONAL DISPOSITION OF DELETE WILL BE IGNORED FOR FILE USER1.PG34.PRICFI.DAT, EXCEPT FOR ABENDS WHICH SAS CANNOT
RECOVER.
NOTE: CONDITIONAL DISPOSITION OF DELETE WILL BE IGNORED FOR FILE USER1.PG34.PRICFI.DAT, EXCEPT FOR ABENDS WHICH SAS CANNOT
RECOVER.
DB2 NOTE: The QUERYNO for the EXPLAIN is 7113174
NOTE: TABLE WORK.VCOLUMN CREATED, WITH 12 ROWS AND 5 COLUMNS.
NOTE: THE PROCEDURE SQL USED 0.01 CPU SECONDS.
NOTE: THE FILE FLATOUT IS:
DSNAME=USER1.PG34.PRICFI.DAT,
UNIT=3390,VOLUME=AP0515,DISP=NEW,BLKSIZE=27998,
LRECL=6160,RECFM=VB,CREATION=2024/07/11
NOTE: 1 RECORD WAS WRITTEN TO THE FILE FLATOUT.
THE MINIMUM RECORD LENGTH WAS 128.
THE MAXIMUM RECORD LENGTH WAS 128.
NOTE: THERE WERE 12 OBSERVATIONS READ FROM THE DATA SET WORK.VCOLUMN.
NOTE: THE DATA STATEMENT USED 0.01 CPU SECONDS.
DB2 NOTE: The QUERYNO for the EXPLAIN is 7113174
NOTE: THE FILE FLATOUT IS:
DSNAME=USER1.PG34.PRICFI.DAT,
UNIT=3390,VOLUME=AP0515,DISP=MOD,BLKSIZE=27998,
LRECL=6160,RECFM=VB,CREATION=2024/07/11
NOTE: 0 RECORDS WERE WRITTEN TO THE FILE FLATOUT.
NOTE: THERE WERE 0 OBSERVATIONS READ FROM THE DATA SET WORK.PRICFI.
NOTE: AT LEAST ONE W.D FORMAT WAS TOO SMALL FOR THE NUMBER TO BE PRINTED. THE DECIMAL MAY BE SHIFTED BY THE "BEST" FORMAT.
NOTE: THE DATA STATEMENT USED 0.01 CPU SECONDS.
Field in question is CIC_PREM_UNRND. When the system shifts to "BEST" FORMAT it moves the decimal 4 places to the left. Is it possible to define the field in the select statement so we don't have the decimal moved 4 places? Thanks
... View more
