DSXchange

Thanks Ray. It worked. Actually when reading the file before I was using \x1A, so in filed function I was trying with that and just 1c (I kind of know that this is wrong as the data may contain 1c) which are the hexadecimal values. Thanks ssnegi for the alternative. But I wanted to do that in Datast...

No I am not asking about how to find what is the character. Suppose in the file the data is delimited by ASCII 26, like A(ASCII 26)B, when I define single column in seq file stage and click on view data, I ma seeing AB in place of non printable character I don't see a box or anything. Later I want t...

Our file has different record types. It is a text file with ASCII data. Delimiter is a non printable character. I am trying to read the data in single column and then divide the records. But when I am trying to read the data in single line, when I say view data I could not see the non printable char...

It is solved as there is FK relationship on the table to itself and it is entering loop. That FK is not indexed. But after indexing it it is resolved.

I am trying to perform Delete statement on DB2 (on mainframe). Job Design. Dataset -> Xfmr -> DB2 CONNECTOR I am deleting based on PK ID. I am getting a message as mentioned below. The execution of the query will not be atomic because the database server does not support atomic operations for non-in...

Ray, but we are in development phase and potentially there are no other users that might be accessing it, and also the table there is Error table which we are using for audit purpose. So I am mostly sure that I am the only user accessing it.

asorrell, I have changed the sql in the insert statement and defined clob columns at the end. Still I got the same error.

Our DB2 is on mainframe and we are connecting through a gateway. So I guess we can't use it atleast in 8.1 version.

I am getting an error while running the job to insert data into a DB2 table. Our DB2 is on Mainframe and we are connecting through a gateway. The error I am getting is TABLE_ERROR,0: SQLExecute reported: SQLSTATE = 40003: Native Error Code = -1224: Msg = [IBM][CLI Driver] SQL1224N The database manag...

Thanks,

I was able to batch them, based on both the conditions

Hello, My requirement is right now I am assigning a unique number for every 500 numbers with the logic @INROWNUM/500. But the requirement changed so that, I could accomodate this with the change of date or for every 500 numbers. If there are 100 rows with 100 different posting dates I need to create...

Thanks for the reply.

Thanks for the reply Mod(@INROWNUM,10) = StageVar -- If StageVar = 0 Or @INROWNUM =1 Then 'H' Else 'D' Above is my current logic for assigning header and detail for every 10 records, it works for all records but not in the case of first 10 records I need to uniformly divide them right now my headers...

I am able to keep the ongoing sum. But after summation, I need to introduce a new row at 11th position which makes the total of 11 rows = 0 e.g.; consider sum of 10 rows to be 100, the value in the 11th row should be -100. And if the sum of next 10 rows from 12th position to 21st postion is -50 the ...

Hello, My requirement is, I get data from a table with approx 75,000 rows. Right now I need to separate them into chunks of 10 rows. I have 2 columns which must be summed for every 10 rows based on the sum I need to generate another row which makes the total sum of the previous 10 rows zero. My appr...