How to find out no. of business days in a month using macros.???(excluding weekends and holidays).
2 10554I have a value prompt in my prompt page.Now if I set the filter to required then I have to select a value from the list and I will get the respective data in the report page.But If I select nothing then I will get the complete data in the report page. I want that if I select nothing from the prompt list then nothing is displayed in my report page. How should I do this?
1 6616I have created a command that display Source file and library. Now i want that when i enter library name and press f4 on Source file, pgm should display all the PF- SRC's in that Library. For F4 option i have used Choice program but since only limited paramters are passed in Choice pgm i am not able to paas library name and further can't call a pgm that will display list of Source files. Below is the Code snippet for CMD type object :- CMD PROMPT('Source Scan for HUB Standard') PARM KWD(SOURCE) TYPE(*CHAR) LEN(1) RSTD(*YES) + VALUES(N A) MIN(1) + CHOICE('N,A') PARM KWD(SRCFILE) TYPE(FILE) RSTD(*NO) + PROMPT('SOURCE FILE') FILE: QUAL TYPE(*NAME) LEN(10) RSTD(*NO) EXPR (*YES) + CHOICE(*PGM) + CHOICEPGM (XXXXXLIB/YYYPGM) QUAL TYPE(*NAME) LEN(10) DFT(*LIBL) + SPCVAL((*LIBL)) EXPR(*YES) PROMPT ('Library') Below is the Choice pgm:- PGM PARM(&PARM1 &PARM2) DCL VAR(&PARM1) TYPE(*CHAR) LEN (21) DCL VAR(&PARM2) TYPE(*CHAR) LEN (2000) IF COND(%SST(&PARM1 1 10) = 'CHOICE ' *AND + %SST(&PARM1 11 10) = 'SRCFILE ' *AND + (%SST(&PARM1 21 1) = 'C' *OR %SST (&PARM1 + 21 1) = 'P')) THEN (DO) /* (%SST(&PARM1 21 1) = 'C' *OR %SST (&PARM1 + */ CHGVAR VAR(&PARM2) VALUE('Name, F4 for List') ENDDO IF COND(%SST(&PARM1 1 10) = 'CHOICE ' *AND + %SST(&PARM1 11 10) = 'SRCFILE ' *AND + %SST(&PARM1 21 1) = 'P') THEN (DO) CHGVAR VAR(&PARM2) VALUE('Name, F4 for List') CALL PGM(GTSQL) PARM ('XXXXLIB') return ENDDO Thanks in Advance for looking into.
3445While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?
2 7915Post New HSBC Interview Questions
How to update a resultset programmatically?
How to execute more than one sub jobs parallel in talend
What is the use of inner class?
please guide me who to prepare for bel interview...
How to integrate hibernate and spring?
Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?
Explain how far from earth, is the moon?
How to use the json object in ng-repeat?
How do I free up disk space?
You are a project manager for Candy Works candy factory. Your project involves reporting information from the newly installed candy-counting machine to the financial system. This will give executives the ability to see production run counts at any time during the day. You need to purchase an expensive piece of hardware as part of this project. One of the vendors bidding on the project is a close friend. In order to win the bid, she needs to know how much money the company is willing to spend on the equipment and consulting. Your friend asks you to give her this confidential information and not tell anyone you did. Which of the following is the most appropriate response? A. Tell your friend that as a PMP, you're required to abide by the Project Management Professional Code of Professional Conduct and this would violate the code as it's a conflict of interest. B. Tell your friend that as a PMP, you're required to abide by the Project Management Professional Code of Professional Conduct and this would violate the code as it’s a personal gain. C. Tell your friend that as a PMP, you're required to abide by the Project Management Professional Standards and Ethics Code and this would violate the code as it’s a conflict of interest. D. Tell your friend that as a PMP, you’re required to abide by the Project Management Professional Standards and Ethics Code and this would violate the code as it’s an ethics violation.
What is syswow64 virus?
How can we decide weather we can enhance the standard infotype or not ? : abap hr
What is a null check?
What are some indications that you need to increase the shared_pool_size parameter?
What is teradata? What are some primary characteristics of teradata?