How to find out no. of business days in a month using macros.???(excluding weekends and holidays).
2 9606I 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 6006I 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.
3028While 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 6749Post New HSBC Interview Questions
Can you install windows 7 over xp?
How do I use gmail instead of outlook?
What is the proper way of setting up an android-powered device for app development?
HI, i was given only 1st round and i made it through the first round, then was sent for the final HR round.In the HR round the HR manager dint ask me a single question of the related job,all he asked was as following:- i)what are your salary Expectations ii)are you ok to do night shifts.then he thanked me and said he will let me know by 2 days,when i asked him for any feedbacks and suggestions he said that he will let me know only after 2 days.SO please help me what shall i expect from this one of a kind interview. Many thanks in advance.
What are the uses of microsoft power point?
Is there a case when finally will not execute?
What is slice notation in python to access elements in an iterator?
What are the main features of ms word?
what JCL Procedures?
Name some of the sectors where iot played a major role?
Is there difference between the initial and the final energy levels in catalyzed and non-catalyzed reactions?
What are the problems with Hadoop 1.0?
How are the consignment stocks created?
What are image sprites?
Can any particular component of .net framework 3.0 be removed?