DB2 doesn't provide direct equivalents to these operations, but the most common uses of FORALL and BULK COLLECT can be efficiently mapped to statements involving UNNEST and ARRAY_AGG, respectively. DB2不提供这些操作的直接等效操作,但是FORALL和BULKCOLLECT的最常见使用可有效地分别映射到涉及UNNEST和ARRAYAGG的语句。
The ARRAY_AGG function is a column function that aggregates values into an array. ARRAYAGG函数是将值汇集到阵列中的列函数。
To make such conversions between arrays and tables possible, DB2 provides the new ARRAY_AGG function and UNNEST operator. 要使阵列和表之间的转换成为可能,DB2要提供新的ARRAYAGG函数和UNNEST运算符。
Let's now see how Oracle's BULK COLLECT can be mapped to ARRAY_AGG. 现在让我们看看如何将Oracle的BULKCOLLECT映射到ARRAYAGG。
We selected our database, named rss_agg and wrote a very simple SELECT statement to retrieve all records from the feeds table. 我们选择了数据库,命名为rssagg,并编写了一条十分简单的SELECT语句从feeds表中检索所有记录。
Simple uses of ARRAY_AGG can be expressed equivalently using array constructors by query. 使用通过查询的阵列构造函数可以等效地表示ARRAYAGG的简单使用。
However, the ARRAY_AGG function can also be used in statements that return more than one row and/ or more than one column. 然而,ARRAYAGG函数还可用于返回多行和/或多列的语句。
Organiser Agg wishes to remind all travelling LFC supporters that they will be once again be acting as ambassadors for Liverpool FC and the City of Liverpool. 组织者阿格希望提醒所有出行的利物浦球迷,他们会再次担任利物浦足球俱乐部以及利物浦城的亲善大使角色。
AGG assault does seemto be your specialty. 似乎你很擅长攻击他人。
E Agg EC, as identified with the Hela cell assay or by hybridization with the E Agg EC probe were not associated with diarrhea in children in China. 用Hela细胞试验或用E(Agg)EC探针杂交作鉴定的E(Agg)EC与广州儿童的腹泻病无关。
Results In all 43 samples, the K ras codon 11 was CCT ( proline), and the opposite strand sequenced was AGG. It was different from the standard GCT ( Alanine) sequenced by foreign authors. 结果所有43例标本中K-ras基因第11位密码子均为CCT(编码脯氨酸),用对侧链测定为AGG,与国外测定的标准序列不同,考虑可能为人种变异。
Biotin-Avidin system was used in latex agg-lutination test for antibody against HBsAg. 将生物素-亲合素系统引入胶乳凝集试验,用于抗-HBS的检测。
E Agg EC may cause diarrhea in children in whom no other enteric pathogens have been identified. 腹泻儿童中在未发现其他肠道病原菌的情况下,E(Agg)EC可引起腹泻。
Methods ( 1) cTnT was amplified by PCR from cardiac cDNA and consecutive AGG codons in the cDNA of cardiac troponin was replaced with the synonymous codon. 方法(1)PCR扩增心肌肌钙蛋白T基因cDNA及其连续稀有密码子的同义替换;
Conclusion The formation of microaggregates of platelets in liver sinusoids may be the cause for the decreasing platelet amount and AGG in patients with hepatolithiasis having a histoy of cholangitis. 结论肝胆管结石病人血小板量及聚集性下降,可能与肝脏微聚物形成有关;
E. coli that adhered to Hela cells in an aggregative pattern and hybridized with the E Agg EC probe were of 27 O: H serotypes and no serotype was associated With diarrhea dis'ease. 聚集性模式中粘附Hela细胞和用E(Agg)EC探针杂交的E·Coli,有27个O:H血清型及无血清型与腹泻有关。
Clinical measurement of platelet amount and AGG plays an important reference role in operation determination and prognosis evaluation. 临床测定血小板量及AGG对手术决策,预后估价具有重要的参考意义。
RESULTS The maximum apparent stoichiometric ratios of noncovalent complexes i-RNA/ HSA and i-RNA/ AAG were 4 ∶ 1 and 3 ∶ 1, respectively. 结果i-RNA与HSA和AGG形成非共价结合复合物的最大表观化学计量比分别为4∶1和3∶1。
Methods The amounts and aggregation of platelets in venous blood were measured in 40 patients with hepatolithiasis by PPP automatic platelet aggregometer and liver biopsies were also made. 方法采用血小板聚集仪测定40例肝胆管结石病人血小板量、血小板聚集率(AGG),同时行肝活检术。
AGG is the second stop codon of swamp water buffalo, and it is a significant and unique characteristic of lineage B in Chinese swamp water buffalo. AGG是中国沼泽型水牛支系B的一个显著而独特的特征。
The effects of dosage of sodium hydroxide, alkalization time, dosage of sodium chloroacetate, negative-ionization time and temperature on the carboxyl group content and viscosity of AGG were investigated respectively. 考察了碱用量、碱化时间、阴离子化试剂用量、阴离子化时间及反应温度等因素对两性瓜尔胶羧基含量和粘度的影响,优化了两性瓜尔胶的制备工艺。
Meanwhile, investigation of carbides distribution with the variation of time at 1120 ℃ with backscatter electron image ( BSE) was conducted to study its influence on AGG. 同时通过扫描电镜背散射电子成像分析,得出了1120℃下,随加热时间变化,碳化物的分布演变,探讨了其对AGG的影响规律。