How to code Page up and Page down in RPG for Single page subfile without using ROLLUP/ROLLDOWN in DSPF ?
3 18089my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica
1 4344I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?
1 9220create or replace procedure show_tab_rec ( P_tab VARCHAR2 )
IS
cmd varchar2(50);
begin
cmd := 'select *
from '|| P_tab;
for int in ( execute immediate cmd )
loop
dbms_output.put_line ( int.ename||' '||int.deptno);
end loop;
end;
when i m compling this procedure i m getting this error
PLS-00103: Encountered the symbol "IMMEDIATE" when expecting
one
of the following:
. ( ) , * @ % & | = - + < / > at in is mod remainder not
range rem => ..
what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .
5 19566Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?
8 28704Post New HCL Interview Questions
In the 7 Stages of the SDLC (Planning, System Analysis, System Design, Development, Testing, Implementation, and Maintenance), WHO are the stakeholders of each stage?
Explain static reports?
What is data modelling concepts?
Why does it take so long to detect that the peer died?
For which header list, the last node contains the null pointer?
What is checkpoint process in the sql server?
Explain different types of index?
What is the purpose of plug-in tag in struct-config.xml?
what is a transaction and what are acid properties? : Sql server database administration
What is bean-managed transaction?
As you achieve greater success with the company after some years, Will you like to be a share holder in our company?
Explain one of your marketing innovations that you have done till now?
Can action method static?
Can variables be declared anywhere in c?
What is the default Port No on which SQL Server listens?