× Discuss about Archiving, Close of Business, Delivery Setup, Security Management System, Global Processing etc…

tJED not working on R18 TAFJ

  • MasterL
  • Topic Author
  • Visitor
  • Visitor
5 years 8 months ago #22046 by MasterL
tJED not working on R18 TAFJ was created by MasterL
First of all, the available resources online that I've come across show that the command is a simple:
tJED <FILE> <RECID>
e.g.
tJED F.USER INPUTTER
When I run that T24 throws the error "Missing user/credentials, please provide a valid user and password: -u username -p password"

So I created a user using the tUserMgnt command. The tAddUser apparently doesn't work in R18.
tUserMgnt --add -u user -p P#ssword1

Now when I run the tJED command
tJED F.USER INPUTTER -u user -p P#ssword1
I get the error OPEN FAILED: -p
And that happens for any record I try to JED.

I know I can user DBTools but I haven't found a way to edit (create) a new record using the JED in DBTools.

Please Log in or Create an account to join the conversation.

More
5 years 8 months ago #22048 by phaysalshaikh
Replied by phaysalshaikh on topic tJED not working on R18 TAFJ
Are you using MSSQL ? as DB ?

Please Log in or Create an account to join the conversation.

  • MasterL
  • Topic Author
  • Visitor
  • Visitor
5 years 8 months ago #22050 by MasterL
Replied by MasterL on topic tJED not working on R18 TAFJ
Nope. H2 database for model bank
Running on Windows

Please Log in or Create an account to join the conversation.

  • TUAN
  • Visitor
  • Visitor
4 years 11 months ago #22454 by TUAN
Replied by TUAN on topic tJED not working on R18 TAFJ
same problem.

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #23997 by shikha
Replied by shikha on topic tJED not working on R18 TAFJ
facing the same issue, any solution?

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #23999 by phaysalshaikh
Replied by phaysalshaikh on topic tJED not working on R18 TAFJ
do not use tJED, just create a DBTools user from above solution.
and directly use,
DBTools -u <UserName> -p <Password>
JQL
JED F.USER INPUTTER

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #24000 by shikha
Replied by shikha on topic tJED not working on R18 TAFJ
I am already having a user created before, now I want to changes the value of 6th field but when I am using the below command it is asking for username and password. Is there any way to pass username and password with this command only as I need to automate this task?

Sample command:
tJed -s F.USER <Service Name> 6=<Action>

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #24001 by phaysalshaikh
Replied by phaysalshaikh on topic tJED not working on R18 TAFJ
Are you able to see DBTools screen, which shows the JQL, SQL and other modes ?

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #24003 by shikha
Replied by shikha on topic tJED not working on R18 TAFJ
Yes, I can see the modes.

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago - 1 year 9 months ago #24004 by phaysalshaikh
Replied by phaysalshaikh on topic tJED not working on R18 TAFJ
on that screen do following

JQL JED F.USER INPUTTER

i 6
<any data>
Enter
press small s
press small x
Last edit: 1 year 9 months ago by phaysalshaikh.

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago - 1 year 9 months ago #24006 by shikha
Replied by shikha on topic tJED not working on R18 TAFJ
Now I can see the editor to edit the value but is there any other way to pass the value in the command itself like I want to change the value of field 6 from STOP to START? Is it possible to pass username, password and update task in command line or in a script directly?
 
Last edit: 1 year 9 months ago by shikha.

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #24007 by phaysalshaikh
Replied by phaysalshaikh on topic tJED not working on R18 TAFJ
First of all you are accessing wrong application, the command you are looking for is below

JQL JED F.TSA.SERVICE <SERVICE-NAME>
i 6
Enter
START
Enter
Small s
Small x

Don't worry if you are writing somewhere and cursor is somewhere else, because you chose the filed number correctly. Which is number 6.

No this is the most clean method of editing, with command I don't prefer because you will never know what is happening behind the scenes.

Please Log in or Create an account to join the conversation.

Time to create page: 0.098 seconds