Pages: 1

Post reply

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » alias AS400, extraction Member

#1 2012-06-07 22:20:12

surfary
New member
Registered: 2012-05-15
Posts: 9

alias AS400, extraction Member

Tags: [db2]

hello
I want to recover data from a member of an AS400 file.

To AC, I must create an alias on this file (ex CREATE ALIAS FOR myAlias ​​myFichier (MemberName)  )

Then I have more than done a select * from myAlias ​​to recover data from a member of the AS400.

I am trying to create an alias via tInputAs400, the alias is created but I have a java error (probably because this does not have such a request Select)
Have you any idea how to create this alias

Thank you in advance

Offline

#2 2012-06-08 05:04:38

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: alias AS400, extraction Member

Hi

Could you show me the error log?

Regards,
Pedro

Only Paranoid Survive.

Offline

#3 2012-06-08 09:19:37

surfary
New member
Registered: 2012-05-15
Posts: 9

Re: alias AS400, extraction Member

Hi
in tAS400Input, I have: "CREATE ALIAS  BIB.MYALIAS FOR BIB.ETCAN0 (M123456)"
when running, the alias is created but I get the error:
[statistics] connected
Exception in component tAS400Input_1
java.sql.SQLException: Cursor state not valid.
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:389)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:366)
    at com.ibm.as400.access.AS400JDBCStatement.executeQuery(AS400JDBCStatement.java:2143)
    at projettdetest.tempo2_0_1.tempo2.tAS400Input_1Process(tempo2.java:281)
    at projettdetest.tempo2_0_1.tempo2.runJobInTOS(tempo2.java:909)
    at projettdetest.tempo2_0_1.tempo2.main(tempo2.java:777)
[statistics] disconnected

Last edited by surfary (2012-06-08 09:43:42)

Offline

#4 2012-06-08 09:46:36

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: alias AS400, extraction Member

Hi

I'm afraid that you cannot use "CREATE ALIAS FOR BIB.MYALIAS BIB.ETCAN0 (M123456)" or something like this in tAS400Input...
Try it with tAS400Row, please.

Regards,
Pedro

Only Paranoid Survive.

Offline

#5 2012-06-08 11:31:29

surfary
New member
Registered: 2012-05-15
Posts: 9

Re: alias AS400, extraction Member

Hi pedro,
Wonderfull, it works very well with the tAS400Row
There must be a small bug in the tAS400Input

thank you very much

Offline

#6 2012-06-08 11:34:34

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: alias AS400, extraction Member

Hi

That's not a bug. smile

The usages of tAS400Input and tAS400Row are different.
tAS400Input can not support "create" sql statement in it. It isn't a sql builder.

Regards,
Pedro

Only Paranoid Survive.

Offline

#7 2012-06-08 11:54:58

surfary
New member
Registered: 2012-05-15
Posts: 9

Re: alias AS400, extraction Member

Pedro you are right,
thank you to you for your help anyway smile

Offline

Post reply

Pages: 1

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » alias AS400, extraction Member

Board footer

Powered by FluxBB