OpenLLM-France/wikimedia huggingface dataset:
# SQL\400/Introduction

SQL/400 is a proprietary dialect of SQL for the IBM AS/400, which was later rebranded as iSeries and finally as SystemI, business eServer Computer Platform. It comes in several flavors, or ways that SQL can be run.
* Interactive SQL/400 which can be run from the Command line. Invoke STRSQL {Start SQL/400} and get at what looks like another command line, where we can key in SQL statements for immediate execution, and/or use the F4 Prompt function to navigate IBM DB2/400 data base, which is a version of UDB, IBM's Universal Data Base to get at the 400'ds files (tables) and their fields (columns), for incorporation in the SQL statement. Interactive SQL/400 is often used to identify statements needed to perform various programming actions. When exiting an Interactive SQL/400 session, we have the option of saving a log of our activity, from which our successful SQL/400 statements may be copied into one of the other flavors of SQL/400.
* SQL Query Manager is used to design and store SQL queries used to extract information, generate reports, and create procedures. Query Manager is an interface to SQL in which end users, unfamiliar with SQL, the programming language, can be prompted through what is needed to create inquiries and reports that are more sophisticated than what can be created by other tools, and can be rerun as needed.
* Static Embedded SQL involves SQL statements hard coded inside another high level language program, such as RPG/400, Cobol/400, C/400, and REXX. This is done because there are some areas where SQL is more powerful than other languages, but there are some things they can do that SQL can not. See Comparative Computer Languages. So the AS/400 programmer can pick and choose the Computer Language that is best suited to the needed function, with programs in different languages calling code in other languages a variety of ways.
* Dynamic Embedded SQL
All the AS/400 languages that support Static Embedded SQL also support Dynamic Embedded SQL.

## Languages that support Embedded SQL

* C/400
* Cobol/400
* Fortran/400
* PL/1
* RPG (many different versions of RPG on the 400)
* REXX
# SQL Dialects Reference/Data structure definition/Auto-increment column

A short hint: In most cases auto-increment columns are used as Primary Key columns. In the SQL standard the junction of the two concepts is not mandatory.

## SQL Standard

The SQL standard defines two ways to generate auto-increment values. First, there are identity columns as an extension to exact numeric types. The syntax is: "GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY". Second, the use of sequences in combination with triggers is standardized.

## DB2

Identity columns or sequences combined with triggers (comparison of both techniques).

## Firebird

Is recommended to use sequences combined with triggers . From 3.0 there is Identity support.

## Linter

AUTOINC columns (maybe with RANGEs) or sequences combined with triggers.

## SQLite

Both create an autoincrementing column; the AUTOINCREMENT keyword only prevents reusing deleted values.
# SQL Dialects Reference/Data structure definition/Data types/Character types
#### Character types

This page includes comparison tables which can be big and complex.
While it's perfectly all right to view them in their complete state, it is recommended to install a comparison tables extension that would allow to select particular columns of interest for comparison.
| SQL version | Feature | Standard SQL:2011 | DB2 | Firebird | Ingres | Linter | MSSQL | MySQL | MonetDB | Oracle Vers. 11.x | PostgreSQL | SQLite | Virtuoso |
| ? | Variable-length with limit | VARCHAR(n) | VARCHAR(n) | VARCHAR(n) | VARCHAR(n) NVARCHAR(n) | VARCHAR(n) NVARCHAR(n) | VARCHAR[(n or max)] NVARCHAR[(n or max)] | VARCHAR(n) | VARCHAR(n) CHARACTER VARYING(n) | VARCHAR2(n) VARCHAR(n) is slated for deprecation | character varying(n) varchar(n) | TEXT | VARCHAR(n) |
| ? | Variable-length with limit, max size | no limit | ? | 32765 | ? | ? | 2 GB with (max) or 8000 with the fixed limit | 65535 | about 2 GB | 4000 bytes (32767 bytes if MAX_STRING_SIZE = EXTENDED - Oracle 12G) | about 1 GB | no limit (enforced by global, default = 1M) | ? |
| ? | Fixed-length, blank padded string | CHAR(n) | CHAR(n) | CHAR(n) | CHAR(n) NCHAR(n) | CHAR(n) NCHAR(n) | CHAR(n) NCHAR(n) | CHAR(n) | ? | CHAR(n) | character(n) char(n) | N/A | CHAR(n) |
| ? | Fixed-length, blank padded string, max size | no limit | ? | 32767 | ? | ? | 8000 | 255 | ? | 2000 | about 1 GB | N/A | ? |
Notes:
* ↑ uses dynamic typing; allows any type name
# Solitaire card games/Pyramid

In this game, you move cards from the Pyramid (stock) to the foundation

## Rules

The object of the game is to remove pairs of cards that add up to the total of the highest card in the deck from a Pyramid arrangement of 28 cards.
Jacks value at 11, Queens 12, and Kings 13. So the highest value is 13. To set up the Pyramid, one card is dealt face up at the top of the playing area, then two cards beneath and partially covering it, then three beneath them, and so on completing with a row of seven cards for a total of 28 cards dealt. The remaining cards are placed to the side face down. This is the Stock.
To play, pairs of exposed cards can be removed to the Foundation if their values total 13. Thus, Kings can be removed immediately to the Foundation. Cards must not be covered. Thus when an Ace rests on a Queen, that Queen can not be removed.
You may draw cards from the stock one at a time and match it with any exposed card. If no match is made the drawn stock card is still discarded into the Foundation.
Once the stock is exhausted and/or no more pairs can be made, the game ends.
To score, count the number of remaining face-up cards in the Pyramid. A perfect score is, therefore, zero, where all cards have been matched into the Foundation. For the game to be considered won, all cards (cards from the Pyramid and cards from the stock) must be moved to the foundation; the game cannot be won if at least two cards cannot be moved from the stock.

## Variations

* Relaxed Pyramid Solitaire: to be considered won, all cards from the Pyramid must be moved to the foundation; the game can still be won with cards left in the stock.
* Redeals may be allowed.
* Three cards at a time from the stack, repeating until no matches can be made; placing all cards totalling 13 in a stack.
* Alternatively, seven cards are dealt below the Pyramid. These cards can match each other exposed cards in the Pyramid or from the stack.
* Another addition is playing Pyramid Solitaire with a cell, filled either from the tableau or from the waste upcard.
* Several variations allow a card on the Pyramid to be removed in combination with a card covered by the first, so long as neither card is covered by a card not in the combo. For example, in the case of an exposed ace resting on a queen, the queen can be removed with the ace if no other cards are covering them, but if (for example) a jack is also on the queen, the queen cannot be removed. Other versions require that both cards be fully exposed to begin with.
# Solitaire card games/Royal Marriage

The Queen of Hearts is placed immediately on the table while the King of Hearts will be dealt last. The remaining fifty cards are shuffled and placed on the top of the King.
Cards are dealt one at a time to the right of the Queen. When a pair of cards with the same rank or suit are found to be separated by one or two cards, those in-between cards are discarded. Afterward, the player can look for any resulting pairs with in-between cards to be discarded.
The game is won when the King and Queen are brought together -- that is, when only one or two cards remain in between them, which can then be discarded.

## Variations

Royal Marriage is possible to play in-hand, rather than on a surface such as a table. In this case, the deck is held face-down in one hand, with the King being uppermost face-down card and the Queen being held face-up above it. Cards are played from the bottom of the deck onto the Queen, and fanned out to show all cards that could possibly affect play.
Alternatively, the Queen can be played on one end of a surface, and all the cards dealt out at the beginning of the game after it, ending with the King. This allows for some measure of strategy; being able to view the entire sequence of cards allows the player to choose which cards to discard and in what order to ensure a win.
# Solitaire card games/Royal Flush

The game is so called because the aim of the game is to end up with a royal flush of any suit. However, the game is so much mechanical in nature that there is currently no electronic or computer implementation. Its rules are so far included in printed matter such as The Complete Book of Solitaire and Patience Games by Albert Morehead and Geoffrey Mott-Smith and 100 Best Solitaire Games by Sloane Lee and Gabriel Packard.

## Rules

First, the deck is dealt into five piles: two piles of eleven cards and three piles of ten. The player first turns the first pile up and looks for either an ace, a ten, a king, a queen, and a jack, cards which comprise a royal flush. Once such a card is found, the search ends there, with the cards on top of it discarded and those under it left alone. The search then proceeds into the next pile and the search for other cards in the royal flush continues. Also, the suit of the first card found determines the suit of the entire royal flush. When a pile contains no card of the royal flush being searched, the entire pile is discarded. When another royal-flush card is found in a pile, the search continues until all five piles are searched and royal-flush cards are at the top of their piles.
Afterwards, the piles are placed on top of each other in the reverse direction of the deal. So if the deal is from left to right, once the search ends, each pile is placed on its neighbor to the left. (Morehead and Mott-Smith's rule said stated that the piles should be turned face down first before the piles are gathered). The discarded cards are set aside.
Then without shuffling, the remaining cards are dealt this time into four piles. After this, the search the cards of the royal flush begins again with the same procedure already stated above. Once all four piles are searched and regathered, the remaining cards (again without reshuffling) are dealt into three piles. The process continues, and after the gathering of the piles, the cards are dealt into two piles and the procedure begins once more.
When the two piles are regathered, the remaining cards at this point are then dealt into a single pile. Even at this point, the search stops when a royal-flush card is found and the cards on top of it are discarded. The game is won when the cards of the royal flush are the only ones left in the pile and are arranged in any order. If there are any other cards sandwiched among the royal flush cards, the game is lost.

## Variation

To give the game some variation, Lee and Packard (in their book 100 Best Solitaire Games) suggests the player to try other poker hands such as four-of-a-kinds, full houses, or straight flushes. The player can simply look for a specific hand or look for certain cards to include in his/her hand while playing the game.

## References

* ↑ 100 Best Solitaire Games. Cardoza Publishing. 1 September 2013. pp. 51–. ISBN 978-1-58042-562-9.
* ↑ 100 Best Solitaire Games. Cardoza Publishing. 1 September 2013. pp. 51–. ISBN 978-1-58042-562-9.
# Solitaire card games/Seven Up

Cards are dealt in a row. Spot cards (cards that value from ace to ten) are taken at face value, while jacks are valued at eleven, queens at twelve, and kings at thirteen. Groups of any number of cards that are next to each other and total to a multiple of seven can be discarded. A seven can be discarded on its own.
The game is won when all cards have been discarded. The game is lost if all cards have been dealt from the deck, no more matches are possible and cards are left on the row.
# Solitaire card games/Simple Simon
## Rules

At the beginning of the play the cards are dealt all facing the player, starting from 3 columns of 8 cards each, and then 7 columns with 7, 6, and so forth cards until 1.
A card can be placed on any card on the top of a column whose rank is greater than it by one (with no cards that can be placed above an Ace). A sequence of cards, decrementing in rank and of the same suit, can be moved as one. An empty column can be filled by any card. A sequence of cards from the king down to the Ace - all of the same suit - can be moved to the foundations. The object of the game is to place all four suits in the foundations.

## Strategy

A mixed-suit sequence of cards can be moved to a different location, given enough empty columns or parent cards to place intermediate components and sub-sequences of cards on. This is similar to FreeCell only with the individual components of the sequence being the same-suit sub-sequences rather than individual cards as in FreeCell. Note that some implementations of Simple Simon, require the player to do all the moving of the individual components by himself.
# Solitaire card games/Poker Squares

objective: to build the best poker hands using just 25 cards from the deck.

## Rules

The game starts with placing a card onto a space in a 5x5 grid. Placing cards are done one at a time and once a card is placed on the grid, it can no longer be moved.
Once all 25 cards are dealt, points are scored on hands formed horizontally or vertically. The number of points depend on the hierarchy of poker hands. There are two systems of scoring: The English and the American point systems. The English system reflects the difficulty of getting the hands in the game; the American system reflects the difficulty of getting the hands in actual poker. The two systems rate the hands' scores as follows:
| Poker Hand | American Point System | English Point System |
| Royal Flush | 100 | 30 |
| Straight flush | 75 | 30 |
| Four of a kind | 50 | 16 |
| Full House | 25 | 10 |
| Flush | 20 | 5 |
| Straight | 15 | 12 |
| Three Of A Kind | 10 | 6 |
| Two pair | 5 | 3 |
| One Pair | 2 | 1 |
The points scored from each hand are added to the total score. Albert H. Morehead and Geoffrey Mott-Smith suggest (in their book The Complete Book of Solitaire and Patience Games, ISBN 0-553-20621-4 that to win one must score at least 200 points in the American system or 70 in the English system. Because of the application of the point system, this solitaire is more prevalent as a computer game.
Take the image above for instance. Horizontally, the five hands formed were two full houses (jacks full of aces and nines full of sevens), a four-of-a-kind (four eights), Three tens, and a two-pair (sixes and fives). Vertically, four flushes (one for each suit) and a pair of fours are scored. The player therefore scores a total of 197 points (American system) or 66 points (English system).

## Variants

There is also a version of Poker Squares called Poker Shuffle or Switch-a-roo Poker Solitaire. It is played like Poker Squares except when a card is placed on the grid, it can still be moved until all 25 cards are set. This gives flexibility as the premature rearrangement of the cards can still give better hands on the grid than on Poker Squares. It is scored like that of Poker Squares and Lee and Packard's book states that the winning score is 120 points in the English system or 310 points in the American system.
# Solitaire card games/Puss in the Corner

First, the four aces are separated from the rest of the deck and placed side by side in two cards of two, forming a square. The four waste piles, which initially would contain a card each, are located at the corners of the square.
Building on the foundations is up by color (red suits on red, black suits on black, no matter the suit) to kings. The player first examines the cards to move any cards that can be built on the foundations. If a gap occurs, it is not immediately filled. Only one card can be moved at a time.
After the sufficient cards are built, four cards, one at a time, are dealt onto any of the wastepiles (not necessarily one on each waste pile). Afterwards, any cards that can be built to the foundations are moved. There should be no building on the wastepiles themselves. The process is repeated, i.e. dealing four cards any on the wastepiles and moving any available cards (the top card of each wastepile) to the foundations over and over, until the stock is exhausted.
After the stock is exhausted, the player can do a redeal. To do this, the player must pick up the four waste piles in any order one wishes, and without shuffling, restarts dealing four cards, restarting the process. The game ends when this second stock is used up.
The game is won when all the cards end up in the foundations.
# Solitaire card games/Perseverance
## Rules

First, the four aces are taken out of the deck. These form the four foundations.
Then the rest are shuffled and dealt into twelve piles of four cards each. One can distribute one card at a time for each pile or deal four cards at a time to form a pile.
The top cards of each pile are available for play to the foundations or on the tableau piles. The foundations are built up by suit, with the cards on the tableau are built down, also by suit.
One card can be moved at a time. However, the player is allowed to move a sequence of cards as a unit to another pile with an appropriate card (e.g. 6-5-4-3♠ can be placed on the 7♠).
When all possible moves are made (or the player has done all the possible moves one can make), the piles are picked up in reverse order. For example, the twelfth pile is placed over the eleventh pile, and this new pile is placed on the tenth pile, and so on. Then, without shuffling, the cards are dealt to as many piles of four as the remaining decks will allow. To ensure that the order of the cards is not disturbed for the most part, it is suggested that the cards are dealt four at time. This can be done either only twice, or this can be done perpetually until the game is won or becomes blocked.
The game is won when all cards are built onto the foundations up to Kings.
# Solitaire card games/Scorpion

This game is similar to both Spider and Yukon
The game starts with 49 cards dealt into seven columns of seven cards each on the tableau. The first four columns each have three face-down cards with four face-up cards placed over them. The cards in the remaining three columns are all faced up. The three leftover cards are set aside for later.
Cards in the tableau are built down by suit and every face up card is available for play, no matter where in the column it is. That means that any card can be placed on top of a card that is a rank higher. Once a card from the bottom or middle of a column is moved, all cards on top of it are moved as well, as one unit. Nothing can be placed on an ace and gaps on the tableau can only be taken by kings or sequences with Kings as their top cards. Once a face-down card is exposed, it is turned face up.
When no more moves are possible, the three leftover cards are dealt onto the first three columns and put into play.
As earlier mentioned, the object of the game is to build four columns of suit sequences from king down to ace. So when one such column is built successfully, it is a general rule to leave this column alone, unless it covers a face-down card, it allows some "elbow room" for the other suit columns to be formed.
The game is won when the object is fulfilled, that is four columns of suit sequence cards from king down to ace are formed. .

## Variants
### "Scorpion II"

The rules above state the prevalent version of the game. There is also a second version of the game in which the number of columns containing three face-down cards and the number of columns in which all cards are faced up are the reverse of the prevalent version, i.e. the first three columns each have three face-down cards with four face-up cards placed over them while the cards in the remaining four columns are all faced up. Despite the reversal, the game remains the same.

### Wasp

It is played like Scorpion except that when a gap is formed, any card or sequence can be placed in it. This gives the player more chances of winning than in Scorpion.

### Three Blind Mice

Three Blind Mice is another solitaire game which is a variation of Scorpion.
First 10 columns of five cards each are dealt. The three rightmost columns should each have three bottom cards faced down and two top cards face up. The three cards in each of those columns gave the game its name after the nursery rhyme. The five cards in each of the rest of the columns are all face up. The two leftover cards are set aside face up to be used any time in the game whenever necessary.
Game play is the same as in Scorpion.

## Bibliography

* Scorpion (solitaire). (2016, June 8). In Wikipedia, The Free Encyclopedia. Retrieved 03:00, February 1, 2018, from https://en.wikipedia.org/w/index.php?title=Scorpion_(solitaire)&oldid=724330648
# Pinyin/Detained

See also
# Pinyin/Device

See also
# Pinyin/Dialectics

Dialectics is the method of analysis.
biahnzhehngfaa jiuhshih fenxi d fangfaa.
# Pinyin/Diabetes

Search diabetes

## Diabetes

Diabetes is a chronic disease that occurs either when the pancreas does not produce enough insulin or when the body cannot effectively use the insulin it produces. Insulin is a hormone that regulates blood sugar. Hyperglycaemia, or raised blood sugar, is a common effect of uncontrolled diabetes and over time leads to serious damage to many of the body's systems, especially the nerves and blood vessels.
In 2014, 9% of adults 18 years and older had diabetes. In 2012 diabetes was the direct cause of 1.5 million deaths. More than 80% of diabetes deaths occur in low- and middle-income countries.
Tángniàobìng shì yīzhǒng mànxìngbìng, dāng yízàng bùnéng chǎnshēng zúgòu de yídǎosù huòzhě réntǐ wúfǎ yǒuxiào lìyòng suǒ chǎnshēng de yídǎosù shí, jiù huì chūxiàn tángniàobìng. Yídǎosù shì tiáojié xuètáng de hormone. Tángniàobìng bùjiā kòngzhì dǎozhì gāo xuètáng, chángqī huì yánzhòng sǔnhài shēntǐ hěnduō xìtǒng, yóuqíshì shénjīng hé xuèguǎn.
2014 nián, 18 suì yǐshàng de chéngniánrén zhōng yǒu 9% de rén huànyǒu tángniàobìng. 2012 nián, tángniàobìng zhíjiē zàochéng 150 wàn rén sǐwáng. 80% yǐshàng de tángniàobìng sǐwáng fāshēng zài dī shōurù hé zhōngděng shōurù guójiā.

## Type 1 Diabetes

Type 1 diabetes (previously known as insulin-dependent or childhood-onset diabetes) is characterized by a lack of insulin production.
1-xíng tángniàobìng (yǐqián chēngwéi yídǎosù yīlàixíng huò értóngqī fābìngxíng tángniàobìng) de tèzhēng shì bùnéng chǎnshēng yídǎosù.

## Type 2 Diabetes

Type 2 diabetes (formerly called non-insulin-dependent or adult-onset diabetes) is caused by the body’s ineffective use of insulin. It often results from excess body weight and physical inactivity.
2-xíng tángniàobìng (yǐqián chēngwéi fēi-yídǎosù yīlàixíng huò chéngrénqī fābìngxíng tángniàobìng) shì yīnwèi réntǐ bùnéng yǒuxiào lìyòng yídǎosù yǐnqǐ de. Tǐzhòng chāozhòng hé quēfá shēntǐ huódòng chángcháng zàochéng gāi bìng.

## Gestational Diabetes

Gestational diabetes is hyperglycaemia that is first recognized during pregnancy.
Huáiyùnqī tángniàobìng shì zuìchū zài huáiyùn qījiān fāxiàn de gāoxuètáng.
# Pinyin/Diacritic

A diacritic is a mark that shows the pronunciation of a letter.
biahnyinfur shih xiaanshih zihmuu fayin d furhaoh.
# Pinyin/Detect

See also
# Pinyin/Detonate

See also
# Pinyin/Development

See also
Development is the gradual growth of something so that it becomes more advanced, stronger, etc.
fazhaan shih mooushihwuh d zhurjiahn cherngzhaang, biahnde gehng xianjihn, qiarngdah, deeng.