DSXchange

Hi all, We have to deploy the code to production environment soon. The problem is - in the stage environment where we have the code currently, the value for the $APT_CONFIG_FILE parameter has the server name along with the path, eg., / server name /apps/Ascential/......../default.apt is the value. N...

thanks for the replies.

If i use an after job subroutine and query the tables, how to get the actual number of records are updated for that particular run?

Hi all, I would want to know is there any way i can capture the accurate number of records which are inserted/updated to a DB2 table, after running the job? Initially, I was using an after job sub-routine, which will get the link count, but i am not very sure whether it will be 100% accurate, as som...

yes, the file path was incorrect, so it cant create the ouput file. Thanks all.

Hi ArndW ,

We have not hard coded any values, all of them are parameters only, any ways let it check it again.

Hi all, thanks for ur replies. yes there is a where clause missing in the command and I have used the correct command and made it unread and modified the jobs also, now when I run a job, following fatal errors, occured: main_program: Unable to open descriptor file to create: No such file or director...

It is not copy, sorry, export from Production and imported to Development Environment and I made it NRO by the following command:
UPDATE DS_JOBOBJECTS SET READONLY = 'NRO' NAME ='Jobname'

It is not copy, sorry, export from Production and imported to Development Environment and I made it NRO by the following command:
UPDATE DS_JOBOBJECTS SET READONLY = 'NRO' NAME ='Jobname'

hi all, I have a strange problem. I have copied jobs from Production Environment to Development Environment and i have to modify the job with few additional stages. For the stages which are copied, if I right click, "Properties" option is not highlighted and for the other stages which are ...

Hi all, I am using Parallel Ex.I am facing a problem with @INROWNUM. Actually I have a job where I have to write a single record for any number of records from the source. the job looks like this: DataSet->Transformer->Sequential File For any number of records from DataSet, I have to write a single ...

I tried 0x20 also, there is no change, it is the same.

I tried using that vaiable and passing " " space as the value, but it didnot work. still i am facing that problem.

Hi ray,

Thanks for your reply. I agree that I did not give more information on it, as I could not read your complete reply.

Ok, now I have sent that to a txt file and opened in a HEX editor.The Hex values are 00 for every every box., thats is for every character in the table, it is 00.

The APT_STRING_PAD character is is used in the job, with no value passed to it and still the problem persists for records which have space in the input.

can any one help me solve the problem?

Hi all, I facing a problem when data got loaded into a DB2 table. The job has Dataset as a source and it laods into a DB2 table. There is a column of Char datatype with 8 as length , which gets populated inthe table as 8 boxes.( i could not paste it over here). When i viewed the data, it is neither ...