Date
Job Name
27-Jan QUALD028
QUALD028
1-Feb QUALD028
1-Feb MIS117DY and MIS118DY are running for longer time
Installtion of SQL ACCESS
29-Jan FTP SQLA.LINK from ftp.cincom.com
4-Feb QUALDOWN
4-Feb DBQCICST
QUALDOWN
the shutdown is like a warm shutdown
if something is connected it will not happen
the job goes out and see what is connect
that why it does a generic abend s806
we have a couple of jobs like that
that why you need to go into the job and read it
QFN189DY
QNM024DY
QUALDOWN failed with s806 error
11-Feb
CIN.PROD.JCLLIB
mkt023dy SYS2.SRC.PROCLIB
Sapmple working
LSE.JOBTRAC.JCLLIB(MKT028DY)
MIS.APTTEST.PDS
Issue
1.Job output is not visiable in IOF
2.Job Failing with SB37
3.Again Job Failed with SB37 at dataset 'DBA.QUAL1.C$TSTATS'
nning for longer time
Credentials :ftp.cincom.com
00002569
2UvJLypT
SB06
u4095
not happen
QASQLSVR
!!ERROR!! - THIS PREVENTS SHUTDOWN
e job and read it
u000 s0b6
s806 is bogas error. Failed due to QASQLSVR
Date of Action on resolution
31-Jan
31-Jan
2-Feb
1-Feb
1.Run job:CIN1.BASE.SQLACCES.JCLLIB(CSV1SHUT) to get down the opened
region QASQLSVR
2.After completion of above job restart QUALDOWN from top.
1.Run job:CIN1.BASE.SQLACCES.JCLLIB(CSV1SHUT) to get down the opened
region QASQLSVR
2.After completion of above job restart QUALDOWN from top.
CIN1.BASE.SQLACCES.JCLLIB(CSV1SHUT)
CIN1.BASE.SQLACCES.JCLLIB(SERVER)
Resolution
Changed the job card MSGCLASS=D
Alloated more space in secondary allocation using ((cyl,10,10),rlse)
renamed DBA.QUAL1.C$TSTATS to DBA.QUAL1.C$TSTATS.BKP AND allocated 30 secondary extents
restarted from failed step by failed again
Jenny helped
Date
2-Feb
2-Feb
Senerio
Method
search with keywords & wild card
GET_ENTITYSET
adding New columns at odata service level
GET_ENTITYSET
Inserting RECORD
CREATE_ENTITY
Updating RECORD
UPDATE_ENTITY
DELETE RECORD
DELETE_ENTITY
*Function Import
function import search with one value= country*
EXECUTE_ACTION
function import search with 2 values(country,salary)*
Use 2 functions in a single ODATA service
1.EMPBYCountry-->Country,Salary
2.FlightsBYAirlineid-->Airline
EXECUTE_ACTION
Upload a File of name: nithesh.pdf
UPDATE_STREAM
download a file
GET_STREAM
1.Create Princial Entity set for ZUSERINFO table
2.Create Dependent Entity set for Zuserdetails table
3.Use Association and association set
ZUSERINFO is Header table
Zuserdetails is ITEMS table
Job Name
Issue /Pending
ss Phase-2 Load/rename jobs chang check with user for activity date
Raise change Ticket
Table space renames package ---MS Ts name replace pending
Rebinds Time
Check with bala as we are doing rename
Input
Output
IO_TECH_REQUEST_CONTEXT
ET_ENTITYSET
IO_TECH_REQUEST_CONTEXT
ET_ENTITYSET
IO_DATA_PROVIDER
IO_DATA_PROVIDER
IT_KEY_TAB
IV_ACTION_NAME
IT_PARAMETER
ER_DATA
COPY_DATA_TO_R
EF
Date of Action on resolution
h user for activity date
replace pending
th bala as we are doing rename
Query
data searchstring TYPE string.
searchstring = IO_TECH_REQUEST_CONTEXT->GET_SEARCH_STRING( ).
Replace all occurrences of '*' in searchstring with '%'.
select * from ZUSERINFO into
corresponding fields of TABLE ET_ENTITYSET
where firstname LIKE searchstring.
data searchstring TYPE string.
searchstring = IO_TECH_REQUEST_CONTEXT->GET_SEARCH_STRING( ).
Replace all occurrences of '*' in searchstring with '%'.
data itab TYPE ZCL_Z9PM_ODATA_PROJ_01_MPC=>TT_EMP.
data wa TYPE ZCL_Z9PM_ODATA_PROJ_01_MPC=>TS_EMP.
select * from ZUSERINFO into
corresponding fields of TABLE itab
where firstname LIKE searchstring.
loop at itab into wa.
if wa-SALARY >= 60000.
wa-STATUS = 'EXPERIENCED EMP'.
else .
wa-STATUS = 'FRESHER EMP'.
endif.
if wa-COUNTRY = 'INDIA'.
wa-CURRENCY = 'INDIAN Rupee'.
else .
wa-CURRENCY = 'US Dollar'.
endif.
Append wa to ET_ENTITYSET.
endloop.
data wa TYPE ZCL_Z9PM_ODATA_PROJ_02_MPC=>TS_EMP.
IO_DATA_PROVIDER->READ_ENTRY_DATA( importing ES_DATA = wa ).
INSERT into ZUSERINFO values WA.
ER_ENTITY = WA.
data wa TYPE ZCL_Z9PM_ODATA_PROJ_02_MPC=>TS_EMP.
IO_DATA_PROVIDER->READ_ENTRY_DATA( importing ES_data = wa ).
UPDATE ZUSERINFO set FIRSTNAME = WA-FIRSTNAME
LASTNAME = WA-LASTNAME
EMAILID = WA-EMAILID
Phone = WA-PHONE
where USERID = WA-USERID.
data wa_key_tab TYPE /IWBEP/S_MGW_NAME_VALUE_PAIR.
READ TABLE IT_KEY_TAB into wa_KEY_TAB index 1.
if wa_key_tab-value is not initial.
DELETE from ZUSERINFO
where Userid = WA_KEY_TAB-value.
endif.
step1 : Create Project with default settings
step2 : create ENTITY TYPE and ENTITYSET with ddic structure
step3 : Right click Data Model, create FUNCTIOn IMPORT
provide Function Import name = EMPBYCOUNTRY
and continue
step4 : configure INPUT options for Function IMPORT
double click function IMPORT parameters
provide Country with data type Edm.String
step5 : Configure OUTPUT options for FUnction IMPORT
double click Function Import Name
Provide RETURN TYPE kind = ENTITY TYPE
provide RETURN TYPE = EMP
provide cardinality = 0-N ( mincount-maxcount )
provide Return EntitySet = EMPSet
provide HTTP method = GET
data wa_parameter TYPE /IWBEP/S_MGW_NAME_VALUE_PAIR.
data itab TYPE ZCL_Z9PMOASISFI_PROJEC_MPC=>TT_EMP.
case IV_ACTION_NAME.
When 'EMPByCountry'.
Read table IT_PARAMETER into WA_PARAMETER with Key name = 'Country'.
select * from zuserinfo into table itab
where Country = WA_PARAMETER-VALUE.
COPY_DATA_TO_REF( exporting IS_DATA = itab
changing cr_data = er_data ).
endcase.
data wa_parameter TYPE /IWBEP/S_MGW_NAME_VALUE_PAIR.
data wa_Parameter2 TYPE /IWBEP/S_MGW_NAME_VALUE_PAIR.
data itab TYPE ZCL_Z9PMOASISFI_PROJEC_MPC=>TT_EMP.
case IV_ACTION_NAME.
When 'EMPBYCountry'.
Read table IT_PARAMETER into WA_PARAMETER with Key name = 'Country'.
Read table IT_PARAMETER into WA_PARAMETER2 with Key name = 'Salary'.
select * from zuserinfo into table itab
where Country = WA_PARAMETER-VALUE
AND
Salary = WA_PARAMETER2-VALUE.
COPY_DATA_TO_REF( exporting IS_DATA = itab
changing cr_data = er_data ).
endcase.
data wa_parameter TYPE /IWBEP/S_MGW_NAME_VALUE_PAIR.
data wa_Parameter2 TYPE /IWBEP/S_MGW_NAME_VALUE_PAIR.
data flightsitab TYPE ZCL_Z9PMOASISFI_PROJEC_MPC=>TT_FLIGHT.
data airlineid TYPE ZCL_Z9PMOASISFI_PROJEC_MPC=>TS_FLIGHT-AIRLINEID.
data itab TYPE ZCL_Z9PMOASISFI_PROJEC_MPC=>TT_EMP.
case IV_ACTION_NAME.
When 'EMPBYCountry'.
Read table IT_PARAMETER into WA_PARAMETER with Key name = 'Country'.
Read table IT_PARAMETER into WA_PARAMETER2 with Key name = 'Salary'.
select * from zuserinfo into table itab
where Country = WA_PARAMETER-VALUE
AND
Salary = WA_PARAMETER2-VALUE.
COPY_DATA_TO_REF( exporting IS_DATA = itab
changing cr_data = er_data ).
when 'FlightsBYAirlineid'.
READ table IT_PARAMETER into WA_PARAMETER with Key Name = 'Airline'.
airlineid = WA_PARAMETER-VALUE.
Call Function 'BAPI_FLIGHT_GETLIST'
exporting
AIRLINE = airlineid
TABLEs
FLIGHT_LIST = FLIGHTSITAB.
COPY_DATA_TO_REF( exporting is_data = FLIGHTSITAB
changing cr_data = er_data ).
endcase.
data wa TYPE ZCL_Z9PMFILES_ODATA_MPC=>TS_FILE.
data WA_KEY_TAB TYPE /IWBEP/S_MGW_NAME_VALUE_PAIR.
Read Table it_key_tab into WA_KEY_TAB index 1.
Wa-FILENAME = WA_KEY_TAB-VALUE.
wa-SYDATE = sy-datum.
wa-SYTIME = sy-UZEIT.
wa-CONTENT = IS_MEDIA_RESOURCE-VALUE .
wa-MIMETYPE = IS_MEDIA_RESOURCE-MIME_TYPE.
if wa-FILENAME is not initial.
INSERT into ZFILESTABLE values WA.
endif.
data wa TYPE ZCL_Z9PMFILES_ODATA_MPC=>TS_FILE.
data wa_stream TYPE TY_S_MEDIA_RESOURCE.
data wa_key_tab TYPE /IWBEP/S_MGW_NAME_VALUE_PAIR.
READ table it_key_tab into WA_KEY_TAB index 1.
Select single * from ZFILESTABLE into WA
where FILENAME = WA_KEY_TAB-VALUE.
WA_STREAM-VALUE = wa-CONTENT.
WA_STREAM-MIME_TYPE = wa-MIMETYPE.
COPY_DATA_TO_REF( exporting is_data = wa_stream
changing cr_data = er_stream ).
STEP1 : cREATE pROJECT WITH DEFAULT SETTINGS
STEP2 : CREATE entity type ( prINCIPLE entity type ) along with PRINCIPLE ENTITY SET
with DDIC structure = ZUSERINFO
step3 : create ENTITY TYpe ( dependent Entity Type ) along with Dependent Entity Set
with DDIC Structure = ZUSERDETAILS
step4 : right click assocation Folder, click on Create
Provide aSSOCIATION nAME = Association
chose Principle Entity TYPE = UserHeader
chose cardinality = 1
chose Dependent ENtity TYPE = UserITEMS
chose cardinality = 0-N
provide Navigation property = NP_ON_USERID
click on Next
step5 : define Referential Constraint , between PRinciple ENTITY TYPE and dependent ENtity
type
i,e Userid is referential constraint ( common field )
click on Next
step6 : provide Association Set = AssociationSet
provide PRINCIPLE ENTITYSET = USERHEADERSET
provide DEPENDENT ENTITYSET = USERITEMSSET
click on next and finish
step7 : Generate Runtime Objects
Resolution
Gateway Url
/sap/opu/odata/SAP/Z9PM_ODATA_PROJECT1_SRV/EMPSet?search=R*
/sap/opu/odata/SAP/Z9PM_ODATA_PROJECT1_SRV/EMPSet?search=*
Open Gateway client
click on "USE as REQUEST"
and PROVIDE NEW record values under HTTP REQUEST
and chose "POST" operation
and execute the service
click on "Use as REQUEST"
Change the record values except key field value.
and click on "PUT" Operation
and execute the service
open GATEWAY client and test the service
/EMPSet('9999')
and chose 'DELETE' operation and execute the service
/EMPBYCountry?Country='INDIA'
/EMPBYCountry?Country='INDIA'&Salary=60000
/sap/opu/odata/SAP/Z9PMFILES_ODATA_SRV/FILESet('filename')
chose ADD FILE and pick the file
and Execute the service with PUT operation ( internally UPDATE_STREAM is executed )
/sap/opu/odata/SAP/Z9PMFILES_ODATA_SRV/FILESet('filename')
execute the service with GET operation ( internally GET_STREAM is executed )
Notes
1.Create and declare required new columns in entitiy set
2.data itab TYPE ZCL_Z9PM_ODATA_PROJ_01_MPC=>TT_EMP.
data wa TYPE ZCL_Z9PM_ODATA_PROJ_01_MPC=>TS_EMP.
1.Create an function import
Steps :1
open EMPBYCountry function import
Steps :2 to pass multiple values in query use &
chose function import parameters
Add new input parameter
Salary with Edm.int32 data type
if we use The datatype of field as RAWSTRING or BINARY data type
MIME type = file TYPE = File extension
SAP UI5/FIORI odata ABAP service
_______________________________________________________________
call create( ) create_ENTITY( ) method
call update( ) update_ENTITY( ) method
call remove( ) delete_ENTITY( ) method
call bindRows( ) get_EntitySet( ) method
call bindElement( ) get_Entity( ) method
call callfunction( ) EXECUTE_ACTION( ) method
class 15.doc
Note : create_stream = use POST operation
update_stream = use PUT operation
GET_STREAM = use GET operation
delete_stream = use Delete Operation
Class 16.doc
NoNote : if association and association set is used , then implement the code
under
GET_EXPANDED_ENTITYSET method in DPC_EXT class
or
NOte :If association and Association Set is not used, then implement the code
under
USERHEADERSET_GET_ENTITYSET method to get Header records
and
USERITEMSSET_GET_ENTITYSET method to get items records based on Selected
Header Recordte : if association and association set is used , then implement the
code under
GET_EXPANDED_ENTITYSET method in DPC_EXT class
