Tutorial by Examples: x

Temp-tables can (and should) be created with indices if you plan to run queries against them. This table has one index (index1) containing of one field (field1). This index is primary and unique (meaning not two records can have the same contents of field1). DEFINE TEMP-TABLE ttTempTable NO-UNDO ...

You can define multiple indices for each temp-table. If you need them - define them. Basically an index matching your query and/or sort order will help performance! DEFINE TEMP-TABLE ttWithIndex NO-UNDO FIELD field1 AS INTEGER FIELD field2 AS CHARACTER FIELD field3 AS LOGICAL IN...

@sorted = sort @list; @sorted = sort { $a cmp $b } @list; sub compare { $a cmp $b } @sorted = sort compare @list; The three examples above do exactly the same thing. If you don't supply any comparator function or block, sort assumes you want the list on its right sorted lexically. This is ...

In addition to peoples.csv (see simple aggregation from a CSV) we have two more CSVs representing products and sales. sales.csv (people_id, product_id): 19,5 6,4 10,4 2,4 8,1 19,2 8,4 5,5 13,5 4,4 6,1 3,3 8,3 17,2 6,2 1,2 3,5 15,5 3,3 6,3 13,2 20,4 20,2 products.csv (id, n...

A Table can be written to a TableSink, which is a generic interface to support different formats and file systems. A batch Table can only be written to a BatchTableSink, while a streaming table requires a StreamTableSink. Currently, flink offers only the CsvTableSink interface. Usage In the examp...

Pre-requisites: Java 7 Hadoop (Refer here for Hadoop Installation) Mysql Server and Client Installation: Step 1: Download the latest Hive tarball from the downloads page. Step 2: Extract the downloaded tarball (Assumption: The tarball is downloaded in $HOME) tar -xvf /home/username/apache...

This method will create a new Excel Spreadsheet. Pass in the fileName which is a full file path name. using DocumentFormat.OpenXml; using DocumentFormat.OpenXml.Packaging; using DocumentFormat.OpenXml.Spreadsheet; using System; .... void Create(string fileName) { using (Sp...

Parent component : import {Component} from '@angular/core'; @Component({ selector: 'parent-component', templateUrl: './parent-component.html' }) export class ParentComponent { users : Array<User> = []; changeUsersActivation(user : User){ user.changeButtonState(); } ...

Java technology is both a programming language and a platform. The Java programming language is a high-level object-oriented language that has a particular syntax and style. A Java platform is a particular environment in which Java programming language applications run. There are several Java platf...

If you need to extract information from a text response, the easiest way is to use Regular Expressions. The matching pattern is very similar to the one used in Perl. Let’s assume we want to test a flight ticket purchase workflow. The first step is to submit the purchase operation. The next step is t...

XPath can be used to navigate through elements and attributes in an XML document. It could be useful when data from the response cannot be extracted using the Regular Expression Extractor. For example, in the case of a scenario where you need to extract data from similar tags with the same attribute...

The CSS/JQuery extractor enables extracting values from a server response by using a CSS/JQuery selector syntax, which might have otherwise been difficult to write using Regular Expression. As a post-processor, this element should be executed to extract the requested nodes, text or attribute values...

JSON is a commonly used data format that is used in web based applications. The JMeter JSON Extractor provides a way to use JSON Path expressions for extracting values from JSON-based responses in JMeter. This post processor must be placed as a child of the HTTP Sampler or for any other sampler that...

When you manually write your performance scripts, you need to deal with correlation yourself. But there is another option to create your scripts - automation scripts recording. On the one hand, the manual approach helps your write structured scripts and you can add all the required extractors at the...

This uses the Dropbox Java SDK to share a file at "/test.txt" with a specific user: List<MemberSelector> newMembers = new ArrayList<MemberSelector>(); MemberSelector newMember = MemberSelector.email("<EMAIL_ADDRESS_TO_INVITE>"); newMembers.add(newMember); ...

This uses the Dropbox Java SDK to retrieve an existing shared link for /Testing/test.txt specifically: ListSharedLinksResult listSharedLinksResult = client.sharing() .listSharedLinksBuilder() .withPath("/Testing/test.txt").withDirectOnly(true) .start(); System....

This uses the Dropbox Objective-C SDK to upload a local file to Dropbox as "/test.txt". [[client.filesRoutes uploadUrl:@"/test.txt" inputUrl:[NSURL fileURLWithPath:@"/local/path/to/test.txt"]] response:^(DBFILESFileMetadata *metadata, DBFILESUploadError *uploadError, D...

This uses the Dropbox Objective-C SDK to get the user's account information from the Dropbox API. [[client.usersRoutes getCurrentAccount] response:^(DBUSERSFullAccount *account, DBNilObject *_, DBRequestError *error) { if (account) { NSLog(@"%@", account); } else if (er...

This uses the Dropbox Objective-C SDK to download a file from Dropbox at "/test.txt". [[[client.filesRoutes downloadData:@"/test.txt"] response:^(DBFILESFileMetadata *metadata, DBFILESDownloadError *downloadError, DBRequestError *error, NSData *fileData) { if (metadata) { ...

Returns the expression as an array. @(Get-ChildItem $env:windir\System32\ntdll.dll) Will return an array with one item @(Get-ChildItem $env:windir\System32) Will return an array with all the items in the folder (which is not a change of behavior from the inner expression.