DSXchange

Try to use Cleanup Resource option from the director and try to logout that process or release any lock on that process.

Hi While reading BIRTH_DATE field of format Date(4) "YYYY-MM-DD" from DB2 database table through DB2 enterprise stage in datastage , is showing a constant default value "1901-01-01" for all the rows at datastage level in spite of different correct date values seen at database lev...

The source and target databases are DB2. I have not yet loaded it into target database.It is showing me in target dataset. Before loading into target dataset iam reusing shared container which is using QualityStagePX. Its input and output columns are also BigInt for that field.

Hi, While mapping BigInt(10) from source to BigInt(10) in target any value above 2,147,483,647 is mapped to a constant value 2,147,483,647. Any value below it is mapped respectively. Even though range of BigInt(2^63) bigger than above value(2^31), what might be the possible reason for such a case to...

Yes that is right.

The number is greater than 3000000000

So i guess the target datatype must be changed or take some lesser values.

The value that iam trying to convert is autogenerated 10 didgit BigInt number i.e. 3000000000. I tried converting it to decimal implicitly, it worked but when i tried assingning that decimal to integer it gave me fatal error "Transformer_10,0: Fatal Error: APT_Decimal::asInteger: the decimal va...

Is BigInt to Integer implicit conversion possible? I want to convert number BigInt(10) to Integer(10) I tried using AsInteger Typecasting function but then to it was giving negative value in the output as it was earlier during implicit conversion. Is it possible to conver as follows BigInt------>Dec...

my sincere apology for that chulett, i missed your post. Yes iam appending the time part manually but do think that is the reason for which it is giving warning beacuse the same warning is given when i convert string to date.

svcon=TrimF(TrimB(DecimalToString(DSLink3.MSBDAY,"suppress_zero"))) var5=If Len(svconv)=6 Then 19:svconv Else If Len(svconv)=7 Then 20:Right(svconv,6) Else "0" If var5<>"0" Then StringToTimestamp(var5[1,4]:"-":var5[5,2]:"-":var5[7,2] : " 00:00:0...

I am trying to load the data into data set. The length of timestamp field i have kept 25 nothing else.

Tried appending " 00:00:00" with leading space also but still the same warning.

in source there is date string "yyyy-mm-dd" to which iam concatination hard coded "00:00:00" and then converting it into timestamp.

Hi, What might be the possible reason for the warning "Conversion error calling conversion routine timestamp_from_string data may have been lost" I am trying to convert the string "yyyy-mm-dd 00:00:00" in timestamp format. what might be the possible solution for avoiding the warn...