Search found 27 matches

by Gius
Tue Jun 09, 2015 8:06 am
Forum: General
Topic: remove strange character
Replies: 9
Views: 4441

well it is exactly what "priyadarshikunal" wrote in is answer => �
it is what i see when i do a select in db2
when i do the oposite with seq () it give me the value 0
by Gius
Tue Jun 09, 2015 7:26 am
Forum: General
Topic: remove strange character
Replies: 9
Views: 4441

well I tried in a transform this :

if DSLink253.PER_FIRST_INITIAL = char ( 65533 ) then 'ok ' else 'ko'

but it always give my ko ...
by Gius
Tue Jun 09, 2015 4:15 am
Forum: General
Topic: remove strange character
Replies: 9
Views: 4441

Well

Convert("�", "", DSLink7.firstInitial)


this not work as when I paste the strange caracter in the transform, it paste

? instead �
by Gius
Tue Jun 09, 2015 4:01 am
Forum: General
Topic: remove strange character
Replies: 9
Views: 4441

remove strange character

hello
in my job , i call a web service that return me in some field this : �
but i'm not able to remove this strange caracter
Someone know how to do this ?
thank you
by Gius
Thu May 07, 2015 4:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: xml file Name
Replies: 2
Views: 5276

xml file Name

Hello, I have a job that use the XML here down ( with a XML input ) I would like to fetch the value for => Field Name="entRecno" But when I inport the XML or XSD I can not see this field, do you now what can I do for this ? thank You - <?xml version="1.0" ?> - <MDSBroadcast> - <B...
by Gius
Thu May 07, 2015 12:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: MQ connector + XML input not processing single message
Replies: 1
Views: 4771

MQ connector + XML input not processing single message

Hello, I'm using an MQ connector ( configure as real time with wait time = -1 ) with XML input. But the problem is when I put a message in the Queue, it doesn't process it. When I put in another message, it processes the earlier message and the new one. configuration for the MQ connector is ; wait t...
by Gius
Wed Apr 15, 2015 5:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stored Procedure output Error mensajes
Replies: 3
Views: 1670

Stored Procedure output Error mensajes

Hello,
When I use in the job a stored procedure stage, it have two output fields
ProcCode , ProcMess

How can I populate those two variables from the Stored Procedure.
Also, when I do a RETURN x in the stored procedure, how can I capturate this value ?

Thank you
by Gius
Mon Mar 23, 2015 4:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: yyyymmdd to timestamp
Replies: 6
Views: 2557

Re: yyyymmdd to timestamp

I'm still trying things, StringToTimestamp( "2015-01-01 11:11:11" ,'%YYYY-%MM-%DD %hh:%nn:%ss') But this simple expresion give me an error Transformer_6,1: Caught exception from runLocally(): APT_ParseError: Parsing parameters "%YYYY-%MM-%DD %hh:%nn:%ss" for conversion "time...
by Gius
Mon Mar 23, 2015 3:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: yyyymmdd to timestamp
Replies: 6
Views: 2557

Re: yyyymmdd to timestamp

I tried this but it give me an error

StringToTimestamp(%DSLink8.PutDate:Left(DSLink8.PutTime,8)
%,[%"%yyyy%mm%dd %hh%nn%ss"%])
by Gius
Mon Mar 23, 2015 2:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: yyyymmdd to timestamp
Replies: 6
Views: 2557

yyyymmdd to timestamp

hello,
I have two variables
var1 is the Date : YYYYMMDD
var2 is the time : HHMMSSTH

and I would like to concatenate those two variable in one, with the timestamp format ?

Thank you for your help
by Gius
Fri Mar 20, 2015 10:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MQ_connector
Replies: 4
Views: 2106

MQ_connector

hello,
I created a job that read from a queue with an MQ_connector.
This job run once.

But there is a way that this job stay up always, like a listen mode and when there is a message in the queue, then this job is executing ?

Thank you