• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

rngdbdump

 11 Replies
 1 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Brett
Basic Member Send Private Message
Posts: 19
Basic Member
1/13/2015 3:41 PM

I am trying to dump data, in a .csv file for a single customer out of ARCUSTOMER and ARCOMMENTS. What is the correct syntax if the dataid is prod9 and the key fields are company=1 and customer=4059?

So far I can get it on screen but I need it in a .csv file. I have rngdbdump -c arcustomer -v company=1 customer=4059. Where do I put the name of the file I want to dump to?

Thanks in advance for any help.

 

Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
1/13/2015 3:48 PM
You'd need to redirect it. Unix: rngdbdump -c arcustomer -v company=1 customer=4059 > filename.csv (perhaps Windows too?) Or if you are in LID, you could rngdbdump -c arcustomer -v company=1 customer=4059 | lashow and do a send to - file.
Brett
Basic Member Send Private Message
Posts: 19
Basic Member
1/13/2015 3:57 PM
Thanks Greg. Works great when the syntax is correct. I just couldn't remember how to put in the filename for the .csv to dump to it. I am using LID by the way.
dcarter
Send Private Message
Posts: 3
6/17/2015 2:01 PM
rngdbdump –c dev cbformats >cbformats.csv returns ‘Extra Parameter Not Understood’
TJ Mann
Veteran Member Send Private Message
Posts: 44
Veteran Member
6/17/2015 2:16 PM
do: count dev cbformats just to make sure your table is there.
BrianM
Advanced Member Send Private Message
Posts: 41
Advanced Member
6/17/2015 2:17 PM

Interesting...  We don't have that table so I tried the exact syntax your using on cucodes and it worked fine.  Not that it helps you much but at least you know the syntax should be correct.

BTM
dcarter
Send Private Message
Posts: 3
6/17/2015 2:25 PM
Yep, count shows 7 records.
BrianM
Advanced Member Send Private Message
Posts: 41
Advanced Member
6/17/2015 2:41 PM

Did you copy and paste the command from anywhere?  I've read that the "-c", if using a copy and paste will produce that error.

BTM
dcarter
Send Private Message
Posts: 3
6/17/2015 2:45 PM
Thanks Brian, that was the problem.
BrianM
Advanced Member Send Private Message
Posts: 41
Advanced Member
6/17/2015 2:47 PM

No problem.... Glad to help!

BTM
Cherie O
Basic Member Send Private Message
Posts: 19
Basic Member
10/3/2016 2:33 PM

trying to run rngdbdump -c gltrans -v obj-id=163 > filename.csv

but getting "Extra Parameter Not Understood"

i am typing it, not pasting and also in Windows, not Unix

Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
12/21/2016 10:03 PM
Cherie: You need the productline in there. rngdbdump -c prodline gltrans -v obj-id=163 > filename.csv