Search found 11 matches

by Alex_sp
Mon Nov 20, 2006 11:10 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: getting data from ldap - active directory
Replies: 0
Views: 2313

getting data from ldap - active directory

Hi to all. Well i'm trying to get some attributes of all users from our ldap. I'm using JNDI adapter like this: -url "ldap://user:pass@ip:389/OU=Usuarios,DC=pol,DC=es??sub?(&(cn=*)(ObjectClass=user))" The result is a XML file with all users with all their attributes (including all valu...
by Alex_sp
Wed Sep 13, 2006 3:18 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Execute a CMD command with -CLI option
Replies: 2
Views: 3816

Execute a CMD command with -CLI option

Hi to all,
I've to execute a dynamic command (CMD) like "mk XXXX" where XXXX takes different values.
I'm using a batch File adapter as target, but I don't know how to code it.
How I can execute a dynamic command? wiht -CLI?
by Alex_sp
Thu Sep 07, 2006 3:20 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Problems with RTI
Replies: 7
Views: 7427

Well, we've solved this error.
In our case, the problem was a duplicated dll file (xerces-c_2_4_0.dll) and the solution is to erase this dll from the directory windows\system32.

:D
by Alex_sp
Tue Sep 05, 2006 8:49 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: process a dynamic query row by row, DBQUERY
Replies: 8
Views: 8063

I think I understand.... can you change the tree and make the input optional (0:1) or (0:S)? That way if you don't get data back you simply have an empty dataset and the runmap can handle things accordingly. I alter the DBID generated trees all the time. well I solved the problem of no records in r...
by Alex_sp
Mon Sep 04, 2006 9:50 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: process a dynamic query row by row, DBQUERY
Replies: 8
Views: 8063

jeje, well, I've a new problem :-( first of all, the input source for the invoked map is set to database and its type tree is the same one as the returned type tree when I executed the previous DBQUERY. If the resulset returned by the dbquery has no record, the invoked map executes the query defined...
by Alex_sp
Fri Sep 01, 2006 1:51 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: process a dynamic query row by row, DBQUERY
Replies: 8
Views: 8063

I like this solution, I am going to try it by this way. it works!!!!, finally I put this: = RUN("GET_RESULT_SELECT.mmc",ECHOIN(1,DBQUERY("SELECT * FROM SD_02_SEVCOS WHERE ("+ + IF(SIZE(TURNO_SV Column:IN_Disponibles) > 0,"TURNO_SV = '"+TURNO_SV Column:IN_Disponibles+&qu...
by Alex_sp
Wed Aug 30, 2006 8:25 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: process a dynamic query row by row, DBQUERY
Replies: 8
Views: 8063

Hi, This is a good way to do, but I can't use with that query: DBQUERY("SELECT id AS idsuceso,codigo AS codsuceso,tipo AS tiposuceso, estado_vehiculo AS estadoveh, estado AS estadosuceso FROM Tabla_sucesos WHERE ("+ + IF(SIZE(codigo_suceso Datos:IN_Datos_suceso) > 1,"codigo LIKE '&quo...
by Alex_sp
Tue Aug 29, 2006 1:56 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: process a dynamic query row by row, DBQUERY
Replies: 8
Views: 8063

process a dynamic query row by row, DBQUERY

hi all, I've to make a dynamic query with dbquery (OR dblookup) Can i send the result of dbquery to a other map in type tree object form with RUN command? Example: SELECT name, last_name FROM customer WHERE name LIKE 'VAR'; 'VAR' is the dynamical parameter. I've a map with an input card that reads a...
by Alex_sp
Mon Aug 28, 2006 9:16 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Problems with RTI
Replies: 7
Views: 7427

Well, from using the RTI/SOA Edition I can tell you that TX jobs are valid for it to handle. However, I'm not sure you can install everything on one server. And you haven't mentioned what you are using on the RTI Agent side of the equation - WebSphere, Web Logic, etc? And how did you setup and conf...
by Alex_sp
Mon Aug 28, 2006 4:12 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Problems with RTI
Replies: 7
Views: 7427

I am not certain that you need to use the RTI components for DataStage TX, which is what you appear to be doing. If I understand correctly, the RTI components allow you to expose server or parallel j ... The problem is that i want to create a web service from a map. When i attach a datastage map to...
by Alex_sp
Mon Aug 28, 2006 1:58 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Problems with RTI
Replies: 7
Views: 7427

Problems with RTI

Hi all, (sorry by my poor English) I try to test a lot of maps that runs correctly but when I use the RTI and i register an opertaion for the service, RTI agent throws me this error: "No Operation Handler is available for Handler Type 'TX'. The RTI Console called the RTI server with illegal arg...