×
Discuss about Archiving, Close of Business, Delivery Setup, Security Management System, Global Processing etc…
tJED not working on R18 TAFJ
- MasterL
- Topic Author
- 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:e.g.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.
Now when I run the tJED commandI 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.
tJED <FILE> <RECID>
tJED F.USER INPUTTER
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
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.
- phaysalshaikh
- Offline
- Senior Member
Less
More
- Posts: 45
- Thank you received: 0
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
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
Running on Windows
Please Log in or Create an account to join the conversation.
- TUAN
- 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.
- shikha
- Offline
- New Member
Less
More
- Posts: 4
- Thank you received: 0
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.
- phaysalshaikh
- Offline
- Senior Member
Less
More
- Posts: 45
- Thank you received: 0
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
and directly use,
DBTools -u <UserName> -p <Password>
JQL
JED F.USER INPUTTER
Please Log in or Create an account to join the conversation.
- shikha
- Offline
- New Member
Less
More
- Posts: 4
- Thank you received: 0
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>
Sample command:
tJed -s F.USER <Service Name> 6=<Action>
Please Log in or Create an account to join the conversation.
- phaysalshaikh
- Offline
- Senior Member
Less
More
- Posts: 45
- Thank you received: 0
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.
- shikha
- Offline
- New Member
Less
More
- Posts: 4
- Thank you received: 0
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.
- phaysalshaikh
- Offline
- Senior Member
Less
More
- Posts: 45
- Thank you received: 0
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
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.
- shikha
- Offline
- New Member
Less
More
- Posts: 4
- Thank you received: 0
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.
- phaysalshaikh
- Offline
- Senior Member
Less
More
- Posts: 45
- Thank you received: 0
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.
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