| Author |
Message |
    
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 10879
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, June 29, 2009 - 4:35 pm: |
|
Evo_rendu:hemesh idi try cheyyu
into table table1
fields terminated by "," optionally enclosed by '"'
trailing nullcols
(gl_number1,
field2 BOUNDFILLER char,
field3 BOUNDFILLER char,
gl_number2 ":field2 || :field3")
ledu ba..same error isthundi...hmm idi elago..field2, field3 anevi table lo create chesi boundfiller ethesi load chesi padesa inka..kakapothe table lo aa field2, field3 anevi waste ga unnattu lekka... |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 10878
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, June 29, 2009 - 4:28 pm: |
|
thanks baa...agu chostha..chrakochesi field2, field3 define chesi padesa table lo..kiki...work ayyindi appudu boundfiller thesesthe....sare nuvvu ichindi koda chostha aagu.. |
Evo_rendu
Mudiripoyina Bewarse
Username: Evo_rendu
Post Number: 4690
Registered: 12-2008
Posted From: 138.32.32.166
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, June 29, 2009 - 4:24 pm: |
|
hemesh idi try cheyyu
into table table1
fields terminated by "," optionally enclosed by '"'
trailing nullcols
(gl_number1,
field2 BOUNDFILLER char,
field3 BOUNDFILLER char,
gl_number2 ":field2 || :field3") |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 10877
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, June 29, 2009 - 4:23 pm: |
|
Evo_rendu:into table table1
fields terminated by "," optionally enclosed by '"'
trailing nullcols
(gl_number1,
gl_number2 ":field2 || :field3")
field2 and field3 anevi table lo columns ga define cheyyaledu ga mama..dirct ga file lo unna next vache fields annitini concatnate chesi table lo unna 2nd column loki load cheyyali.. |
Evo_rendu
Mudiripoyina Bewarse
Username: Evo_rendu
Post Number: 4689
Registered: 12-2008
Posted From: 138.32.32.166
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, June 29, 2009 - 4:23 pm: |
|
aa boundfiller lekunda try cheyyi baa |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 10876
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, June 29, 2009 - 4:22 pm: |
|
Babu:into table table1
fields terminated by "," optionally enclosed by '"'
trailing nullcols
(gl_number1,
field2 BOUNDFILLER,
gl_number2 ":field2 || :field3")
try cheyyi
adendi...error fiedl2 boundfiller daggare vachesthundi ga expected , etc ani |
Evo_rendu
Mudiripoyina Bewarse
Username: Evo_rendu
Post Number: 4688
Registered: 12-2008
Posted From: 138.32.32.166
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, June 29, 2009 - 4:21 pm: |
|
aa field2 ni boundfiller anadam deniki naku ardham kaledu |
Evo_rendu
Mudiripoyina Bewarse
Username: Evo_rendu
Post Number: 4687
Registered: 12-2008
Posted From: 138.32.32.166
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, June 29, 2009 - 4:21 pm: |
|
into table table1
fields terminated by "," optionally enclosed by '"'
trailing nullcols
(gl_number1,
gl_number2 ":field2 || :field3") |
Babu
Bewarse Legend
Username: Babu
Post Number: 13859
Registered: 06-2004
Posted From: 65.208.22.25
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, June 29, 2009 - 4:19 pm: |
|
into table table1
fields terminated by "," optionally enclosed by '"'
trailing nullcols
(gl_number1,
field2 BOUNDFILLER,
gl_number2 ":field2 || :field3")
try cheyyi 
babu garu
|
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 10875
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, June 29, 2009 - 4:13 pm: |
|
google chesthe boundfiller ane isthunnaru antha...endo work avvatam laa  |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 10874
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, June 29, 2009 - 4:12 pm: |
|
SQL*Loader-350: Syntax error at line 8.
Expecting "," or ")", found "BOUNDFILLER".
field2 BOUNDFILLER,
ani error vasthundi load chesthunte  |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 10873
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, June 29, 2009 - 4:12 pm: |
|
nenu ila rasthunna..
into table table1
fields terminated by "," optionally enclosed by '"'
trailing nullcols
(gl_number1,
field2 BOUNDFILLER,
field3 BOUNDFILLER,
gl_number2 ":field2 || :field3") |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 10872
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, June 29, 2009 - 4:11 pm: |
|
nenu oka file ni ctl file use chesi sqlloader tho load chesthunna table loki...file lo data ila undi.
gl_number1, company, costcenter
ippudu table columns ila unnay...gl_number1, gl_number2
nenu ela load cheyyalo ante 1st column ni table 1st column loki and company and costcenter ni concatnate chesi gl_number2 loki load cheyyali...
ippudu ctl file lo ela raayali?? |
Archives - 2009