Kungani Kubalulekile Ukuthola Imibiko Yama-Cognos ane-SQL Eshumekiwe
Ngenxa yesimo sezitatimende ze-SQL ezinamakhodi aqinile, zidinga ukwenganyelwa okuqhubekayo nokugcinwa. Eqinisweni, uma wenza izinguquko kudathabheyisi yakho kungenzeka kube nzima ukukhomba ukuthi yimiphi imibiko enemibono eyakhelwe ngaphakathi kwi-SQL yabo eku-inthanethi. Kuze kube behluleka ukugijima lokho. Ngenxa yokuthi kunzima kanjani ukugcina imibiko nge-SQL eshumekiwe, kubalulekile ukuyikhomba ukuze ubanikeze ukunakekelwa okwengeziwe abakudingayo. Lokhu kunaka kungathatha uhlobo lokususa i-SQL eshumekiwe noma ukubuyekeza i-SQL ukuze ihambisane nezinguquko endaweni yakho yokugcina idatha. Ake sihlole ukuthi singayisebenzisa kanjani MotioI-PI ukukhomba le mibiko “ekhethekile”.
Isetshenziswa kanjani MotioI-PI Yokuthola Imibiko Yama-Cognos ane-SQL Embedded
The Sesha & Faka esikhundleni Iphaneli in MotioPI yakhelwe ukusesha kokucacisiwe kombiko wakho, ukukhomba imibiko ehambisana nenqubo ebekwe nguwe, futhi yenze nezinguquko ezilula kusethi yezinto zeCognos. Namuhla sizosebenzisa isici sokusesha se-Search & Replace ukuthola ngokushesha yonke imibiko esebenzisa i-SQL efakiwe ukuze ukwazi ukuqinisekisa okuqukethwe kwayo, ukuguqula ukuthi kusetshenziswe imodeli, noma ukubasuse ekukhiqizeni ngokuphelele.
-
- Vula iphaneli lokusesha nokufaka esikhundleni ku- MotioPI. Uma kudingeka, nciphisa usesho lwakho ukumboza kuphela izingxenye zesitolo sakho sokuqukethwe, ezingasiza kakhulu uma ukhathazeka kuphela ngesigatshana sesitolo sakho sokuqukethwe noma ukhathazekile ngejubane losesho lwakho MotioPI. Ukunciphisa, khetha inkinobho "Enciphile"
- Khetha amafayela noma ifolda ofuna ukuqhuba ngayo usesho lwakho bese ukhetha inkinobho ethi “>>”.
- Ngena ku “ ”(Ngaphandle kwezilinganiso) emkhakheni wokusesha.
- Cindezela inkinobho "Sesha".
- MotioI-PI izobuyisa yonke imibiko equkethe i-SQL efakiwe kusuka kusesho lwakho.
- Qaphela ukuthi ungafaka igundane phezu kwesifinyezo ukuze ubone umbhalo ogcwele we-SQL yakho.
- Lapho usuyitholile yonke imibiko yakho nge-SQL eshumekiwe, ungayibhala usebenzisa isici sokuthekelisa ku- MotioPI (Ifayela-> Export okukhipha), zihambise endaweni eyodwa zisebenzisa MotioPI ukuze ukwazi ukubathola kalula ngokuzayo, noma wenze noguquko olulula ku-spec usebenzisa isici se- “Miselela” i-Search & Replace Panel.
- Vula iphaneli lokusesha nokufaka esikhundleni ku- MotioPI. Uma kudingeka, nciphisa usesho lwakho ukumboza kuphela izingxenye zesitolo sakho sokuqukethwe, ezingasiza kakhulu uma ukhathazeka kuphela ngesigatshana sesitolo sakho sokuqukethwe noma ukhathazekile ngejubane losesho lwakho MotioPI. Ukunciphisa, khetha inkinobho "Enciphile"
ISIPHUMELELO:
Yileyo ndlela ongasebenzisa ngayo iphaneli lokusesha nokufaka esikhundleni ku- MotioI-PI ukukhomba yonke imibiko ene-SQL eshumekiwe. Ungathola izinzuzo ezimbalwa zamanga usebenzisa le ndlela, kepha lokho kwenziwa ukuze MotioI-PI ayiphuthelwa yimibiko nge-SQL eshumekiwe. Unganciphisa futhi amagama akho okusesha ukuze useshe kuphela i-syntax ngqo yezitatimende zakho ze-SQL. Uma unemibuzo mayelana nokuthi ungayisebenzisa kanjani kangcono iPhaneli Yokusesha Nokubuyisela, mane ubuze ngezansi kumazwana, ngijabule njalo ukwabelana nganoma yiluphi ulwazi lweCognos engingaba nalo!
