Viewing 15 posts - 16 through 30 (of 55 total)
Thank you . duplicate post only for error in my internet connection. sorry about that. I can't find how to delete the duplicate post.
but about your question. This data...
November 1, 2018 at 6:58 am
Thank you for helping me to send my question in correct format.
I send spreadsheet only for say what I want.
In this picture, Cost_Expected field gets returned for...
October 31, 2018 at 10:55 pm
Thank you for helping me to send my question in correct format.
I send spreadsheet only for say what I want.
In this picture, Cost_Expected field gets returned for...
October 31, 2018 at 10:42 am
October 31, 2018 at 12:08 am
October 30, 2018 at 4:09 am
September 26, 2018 at 5:20 am
1. VM type (Vmware, Hyper-V): VMware
2. VM Configuration (number of cores presented, number of vCpu per cores): 2 Sockets, 8 Cores per Socket
3. VM Disk type - pass through, vmdk, SAN:...
September 26, 2018 at 4:40 am
September 24, 2018 at 10:35 am
We just log a few details we...
September 24, 2018 at 10:31 am
This is raw message sample
"MessageCode":"0053","InstrumentId":"IRB3AL010251","Message":"AdAIaEwAAAACAAAAAluoTpFheHh4eHh4eDEwMDM2MiBOT1oxSVJCM0FMMDEwMjUxQUwxUTEyMDE4MDgwNTE2MzQ1NDAwNTMwMDAwMDFBbGJvcnpOci5JSlIyMzA4MDUzMDYwSVJOMjAwMDAxMDAwMDAwMDAgICAwMDAwMDEwNTAwMDBBTDAxIMrM5e3Sx8og5MfmkMfkINHt4e0gx+HI0dLk7dHmIDAwMDAwMCAgIDAwMDAwMDAwMCAgMDAwMDAwMDAwMDAwMCAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDIwMTgwODA1MDBBMDAwMDAwMCAgICAwMDAwMDAwMDAwMDAwMDAgMDAwMDAwMDAwMDAxWjEgICAwMDAwMDAwMDAwMDBJUiBJUlIyMDE4MDgwNCAwMDAwMDAgIDEwMDAwMDAwMDIwMDAwMTAwMDAwMDAwICAgICAgICAgICAgIDIwMDAwMTAwMDAwMDAwMjAwMDAwMDAwMDAxMDDH4cjR0jAyMSAgICAgICAgICAwIDAwICAwMDAwMDAwMDAwMDAwQUwwMTAyICAgICAgICAgICAgICAgICAgICAgICAgICAgIDAwMDAwIDAwMDAwMDAwMDAwMDAgIDAwMDAwMDAwMDAwMDEgMDAwMDAwMDDHzMfR5SDR7eHtIMfhyNHS5O3R5jE0MDIwNTE0ICAgICAgICAwMDAwMDAwMCAgICAgICBJUkIzQUwwMTAyNTggICAgICAgICAgICAgICAgICAwMDAwMDAwMDAwMDAwMDAwMCAgICAgICAgICAgICAwMDAwMDAwMDAwMDEgMDAwMDAwMDAwMDAwMCAgICAgICAgICAgMDAgMDAwMDAwMDAwMDAwMCAgIDAwMDAwMDAwMDAwMCAgMDAwMDAwMDAwMDAwMDAwICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgRSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAyIDAwMDAwMDAwMDAwMDAgMDAwMDAwMDAwMDAwMCAgIDAwMDAwMDAwMDAwMTAwMDAwMDAyNTAwMCAwMDAwMDAwMCAgMDAwMDAwMDAwMDAwMDIwMDAwMTA1MDAwMDAwMjAwMDAwOTUwMDAwMDAwNU8gICAgMDAwMDAwMDAwMDAwMCAwMDAwMDAwMDAwMDAwICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIE5PIDAgNDY5IDY5MTAzMCAgMDQgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDAwMDAxMDAwMTY5ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgMDAwMDAwMDI1MDAwMDAwMDAwMDI1MDAwMjAwMDAxMDAwMDAwMDBGMDAwMDAwMDAwMDAxIDAwICAgICAgICAgICAgMDAwMDAwMDAwMDAwMDAwICAgMDAwMDAwMDAwMDAwMCAwMDAwMDAwMDAwMDAwIDAwMDAwMDAwMDAwMDAgMDAwMDAwMDAwMDAwMCAgAA==","MessageVersionId":"267000000000002"}
and this is parsed message smaple
{"LRLCDIFFHeader":{"Tech_head_Type":1,"ItemCode":2256,"SessionNumber":19560,"ABSMessageNumber":150994944,"MessageNumberForItemCode":150994944,"BroadCastTimestamp":2437851227,"TransMitterSignature":8680820740569200737,"InstumentCharacteristicHeaderType":"1","MarketFeedCode":"00","MarketPlaceCode":"362","FinancialMarketCode":" BK","CIDGrc":"Z4","InstrumentID":"IRB3BK0199C4","CValMNE":"BK1Q4","DEven":"20180721","HEven":"160945","MessageCodeType":"0053","SEQbyINSTandType":"000001"},"InstrumentID":"IRB3BK0199C4","MessageCodeType":"0053","Message":{"ACarValRLC":{"LVal18":"BG.KaraneMRB210312","YVal":"306","SVal":"0","CPyEmet":"IRN","QNmVlo":{"IFt":"2","QMt":"0000100000000"},"CDevNm":" ","ZTitAd":"000000500000","CSocCSAC":"BK01 ","LSoc30":"?????? ??? ???? ?????991222 ","ASecEco":{"CGdSecEco":"00","CSecAtvEco":"00","CSecCompAtv":"00","Filler01":" "},"CEtFnc":"00000000","IValMry":"0","CSegMarEnvLco":" ","XIntOblRte":{"IFt":" ","QMt":"0000000000000"},"YTxInt":" ","DEmisObl":"00000000","DPrRgLivVal":"00000000","DDebAm":"00000000","DFinAm":"00000000","DESop":"20180721","YOPSJ":"00","CGdSVal":"A","CSicoRGAChn":"000000","CQtmJoui":"0","CDevPEmis":" ","PEmis":{"IFt":" ","QMt":"0000000000000"},"YRbAnt":"0","YRbPro":"0","IValAdSrd":" ","DEchPretEmp":"00000000","IDtVote":"0","IDemat":"0","ITpi":"0","ILcoVwap":"1","CGrValCot":"Z4","Filler001":" ","AClasCo":{"NDivCo":"0","NRubCo":"000","NOrdCo":"0000000"},"IMarche":"0","CPyCot":"IR...
September 23, 2018 at 11:18 pm
September 23, 2018 at 10:03 pm
for example such as this link
Insert statement is very simple.
tables has a primary key and only 2-7 columns
for each table I have...
September 23, 2018 at 12:00 pm
Thanks for your hint.
I update my question and new state of my problem.
September 23, 2018 at 11:01 am
Viewing 15 posts - 16 through 30 (of 55 total)