Chifukwa Chake Ndikofunika Kuzindikira Malipoti a Cognos okhala ndi SQL Yophatikizidwa
Chifukwa cha mawu amawu a SQL omwe ali ndi zilembo zolimba, amafunika kuwayang'anira nthawi zonse ndikuwasamalira. M'malo mwake, ngati mungasinthe mu nkhokwe yanu itha kukhala yovuta kudziwa kuti ndi malipoti ati omwe ali ndi malingaliro mu SQL yawo. Mpaka alephere kuthamanga ndiye. Chifukwa cha momwe zimakhalira zovuta kusunga malipoti ndi SQL yophatikizidwa, ndikofunikira kuti muwazindikire kuti muthe kuwasamalira bwino. Izi zitha kukhala ngati kuchotsa SQL yojambulidwa kapena kusinthitsa SQL kuti igwirizane ndi kusintha kosungira kwanu. Tiyeni tiwone momwe tingagwiritsire ntchito MotioPI kuti izindikire malipoti "apadera" awa.
Mmene Mungagwiritse Ntchito MotioPI kuti mupeze malipoti a Cognos okhala ndi SQL Yophatikizidwa
The Sakani & Sinthani Gulu in MotioPI lakonzedwa kuti mufufuze momwe malipoti anu amafotokozera, kuti mudziwe malipoti omwe akukwaniritsa zomwe mwakhazikitsa, komanso ngakhale kusintha kosavuta pazinthu za Cognos. Lero tigwiritsa ntchito gawo lofufuzira la Search & Replace kuti tidziwitse mwachangu malipoti onse omwe amagwiritsa ntchito SQL yophatikizidwa kuti mutsimikizire zomwe zili, kuwasintha kuti agwiritse ntchito mtunduwo, kapena kuwachotsa pakupanga kwathunthu.
-
- Tsegulani gulu la Search & Sinthani mu MotioPI. Ngati zingafunike, chepetsani kusaka kwanu kuti mungolemba zigawo za sitolo yanu, zomwe zingakhale zothandiza makamaka ngati mungokhudzidwa ndi gawo lanu la sitolo kapena mukuda nkhawa ndi kuthamanga kwanu MotioPI. Kuti Mufupikire, sankhani batani "Wopapatiza"
- Sankhani mafayilo kapena chikwatu chomwe mukufuna kusaka ndikusankha batani la ">>".
- Lowani mu " ”(Popanda mawu ogwidwa) m'munda wofufuzira.
- Dinani batani "Sakani".
- MotioPI idzabwezera malipoti onse omwe ali ndi SQL yophatikizidwa pakusaka kwanu.
- Dziwani kuti mutha kuyika mbewa kuti muwone zolemba zanu zonse za SQL.
- Mukapeza malipoti anu onse ndi SQL yophatikizidwa, mutha kuwalemba pogwiritsa ntchito gawo lotumiza kunja mu MotioPI (File-> Export linanena bungwe), asunthire pamalo amodzi pogwiritsa ntchito MotioPI kuti muthe kuzipeza mtsogolomo, kapena ngakhale kusintha kosavuta pamalingaliro pogwiritsa ntchito "Sinthanitsani" gawo la Search & Replace Panel.
POMALIZA:
Umu ndi momwe mungagwiritsire ntchito gulu la Search & Replace mu MotioPI kuti izindikire malipoti onse ophatikizidwa ndi SQL. Mutha kupeza zabwino zingapo zabodza pogwiritsa ntchito njirayi, koma izi zachitika kuti MotioPI sichiphonya malipoti aliwonse ophatikizidwa ndi SQL. Muthanso kuchepa mawu anu osaka kuti mungofufuzira matchulidwe enieni amawu anu a SQL. Ngati muli ndi mafunso okhudza momwe mungagwiritsire ntchito Search & Replace Panel, ingofunsani pansipa mu ndemanga, ndimakhala wokondwa kugawana chidziwitso chilichonse cha Cognos chomwe ndingakhale nacho!