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
Search found 27 matches
- Tue Jun 09, 2015 8:06 am
- Forum: General
- Topic: remove strange character
- Replies: 9
- Views: 4441
- Tue Jun 09, 2015 7:26 am
- Forum: General
- Topic: remove strange character
- Replies: 9
- Views: 4441
- Tue Jun 09, 2015 4:15 am
- Forum: General
- Topic: remove strange character
- Replies: 9
- Views: 4441
- 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
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
- 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...
- 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...
- Wed Apr 15, 2015 5:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Procedure output Error mensajes
- Replies: 3
- Views: 1670
- 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
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
- 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...
- 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"%])
StringToTimestamp(%DSLink8.PutDate:Left(DSLink8.PutTime,8)
%,[%"%yyyy%mm%dd %hh%nn%ss"%])
- 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
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
- 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
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