Vim Li Cas Nws Tseem Ceeb Kom Txheeb Xyuas Cognos Cov Ntawv Tshaj Tawm nrog Embedded SQL
Vim yog qhov xwm txheej nyuaj-coded SQL cov lus, lawv xav tau kev saib xyuas txuas ntxiv thiab kho. Qhov tseeb, yog tias koj hloov pauv hauv koj cov ntaub ntawv nws tuaj yeem yuav luag tsis tuaj yeem txheeb xyuas cov ntawv ceeb toom twg uas tau muaj kev xav hauv lawv SQL kab. Txog thaum lawv ua tsis tiav qhov ntawd yog. Vim tias nws nyuaj npaum li cas los tswj hwm cov ntawv tshaj tawm nrog SQL, nws yog qhov yuav tsum tau txheeb xyuas lawv yog li koj tuaj yeem muab kev saib xyuas tshwj xeeb uas lawv xav tau. Qhov kev saib xyuas no tuaj yeem siv daim ntawv tshem tawm SQL embedded lossis hloov kho SQL kom ua raws li kev hloov pauv rau koj cov ntaub ntawv khaws khoom. Cia peb tshawb nrhiav seb yuav siv li cas MotioPI txhawm rau txheeb xyuas cov ntawv “tshwj xeeb” no.
Yuav ua li cas Siv MotioPI txhawm rau Nrhiav Cognos Cov Ntawv Tshaj Qhia nrog Embedded SQL
cov Tshawb & Hloov Vaj Huam Sib Luag in MotioPI tau tsim los tshawb nrhiav qhov tshwj xeeb ntawm koj daim ntawv tshaj tawm, txheeb xyuas cov ntawv tshaj tawm uas phim cov txheej txheem tau teev tseg los ntawm koj, thiab txawm tias ua qhov hloov pauv yooj yim ntawm cov khoom Cognos. Hnub no peb yuav siv qhov kev tshawb fawb tshawb fawb & Hloov pauv kom txheeb xyuas txhua qhov kev ceeb toom sai sai uas siv SQL embedded yog li koj tuaj yeem txheeb xyuas lawv cov ntsiab lus, hloov lawv los siv tus qauv, lossis tshem tawm lawv los ntawm kev tsim khoom tag nrho.
-
- Qhib Cov Tshawb Nrhiav & Hloov vaj huam sib luag hauv MotioPI. Yog tias xav tau, nqaim koj qhov kev tshawb nrhiav tsuas yog npog ntu ntawm koj lub khw cov ntsiab lus, uas tuaj yeem pab tau tshwj xeeb yog tias koj tsuas yog txhawj xeeb nrog ntu ntu ntawm koj cov ntsiab lus khaws lossis txhawj xeeb txog qhov nrawm ntawm koj tshawb hauv MotioPI. Txhawm rau nqaim, xaiv lub pob "Nqis"
- Xaiv cov ntaub ntawv lossis ntawv tais ceev tseg uas koj xav tshawb nrhiav hauv thiab tom qab ntawd xaiv lub pob ">>".
- Nkag mus rau hauv " "(Tsis muaj nqe lus) hauv kev tshawb nrhiav.
- Nias lub pob "Search".
- MotioPI yuav xa rov qab tag nrho cov ntawv ceeb toom uas suav nrog SQL los ntawm koj qhov kev tshawb nrhiav.
- Nco ntsoov tias koj tuaj yeem nas hla cov ntawv me me kom pom tag nrho cov ntawv ntawm koj SQL.
- Thaum koj tau nyob tag nrho koj cov ntawv tshaj tawm nrog SQL embedded, koj tuaj yeem sau lawv siv cov khoom xa tawm hauv MotioPI (File-> Export output), txav lawv mus rau ib qho chaw siv MotioPI yog li koj tuaj yeem nrhiav tau lawv yooj yim yav tom ntej, lossis tseem ua qhov hloov pauv yooj yim ntawm qhov tshwj xeeb siv "Hloov" qhov tshwj xeeb ntawm Tshawb & Hloov Vaj Huam Sib Luag.
- Qhib Cov Tshawb Nrhiav & Hloov vaj huam sib luag hauv MotioPI. Yog tias xav tau, nqaim koj qhov kev tshawb nrhiav tsuas yog npog ntu ntawm koj lub khw cov ntsiab lus, uas tuaj yeem pab tau tshwj xeeb yog tias koj tsuas yog txhawj xeeb nrog ntu ntu ntawm koj cov ntsiab lus khaws lossis txhawj xeeb txog qhov nrawm ntawm koj tshawb hauv MotioPI. Txhawm rau nqaim, xaiv lub pob "Nqis"
XAUS:
Qhov ntawd yog qhov koj tuaj yeem siv Tshawb & Hloov vaj huam sib luag hauv MotioPI txhawm rau txheeb xyuas txhua daim ntawv tshaj tawm nrog kos SQL. Koj tuaj yeem tau txais ob peb qhov tsis zoo uas siv cov txheej txheem no, tab sis qhov ntawd tau ua li ntawd MotioPI tsis nco ib qho ntawv tshaj tawm nrog kos SQL. Koj tseem tuaj yeem nqaim koj cov ntsiab lus tshawb nrhiav kom koj tsuas yog tshawb nrhiav qhov tseeb ntawm koj li lus SQL. Yog tias koj muaj lus nug txog yuav ua li cas thiaj zoo siv Tshawb Nrhiav & Hloov Vaj Huam Sib Luag, tsuas yog nug hauv qab hauv cov lus, Kuv ib txwm zoo siab los qhia ib qho kev paub Cognos uas kuv muaj!
