Month: August 2019
wget is a utility for download files/content from the Web servers. It supports most of the protocols that are related to the Web such as HTTP, HTTPS, and FTP …
If we want to know what is wget command and its syntax then you can read our previous post. Read: wget command in unix In this post, we will …
DS Macros are built from Data Stage functions and do not require any arguments. A number of macros are provided in the JOBCONTROL.H file to facilitate getting information …
This is one of the most asked DataStage scenario based interview questions. I will solve this problem by taking some sample data. Input file: Sno,name,salary,rank 1,Naveen,10000,2 2,Joe,20000,2 3,David,30000,1 4,Richard,30000,2 …
Each PL/SQL program consists of SQL and PL/SQL statements which from a PL/SQL block. PL/SQL Block consists of three sections: The Declaration section (optional). The Execution section (mandatory). The …
Block Structures: PL SQL consists of blocks of code, which can be nested within each other. Each block forms a unit of a task or logical module. PL/SQL Blocks …
SecondsFromTime function returns seconds portion of a time. Input: time Output: seconds (dfloat) Examples. If mylink.mytime contains the time 22:30:22, then the two following functions are equivalent, and return …
NextWeekdayFromDate function returns the date of the specified day of week soonest after the source date. The day of the week is specified as the full name, for example, …
