DSXchange

Hi,

a table in our database is loaded by multiple jobs and are unknown to us as we just acquired the system.

I need to search for a particlar value passed for this parameter and find out the culprit jobs.

Can you please let me know if there is a way to do it?

Thanks
nsm.

Thanks Ray,

Can you please let me know how to disable NLS in the Project Level for Parallel Jobs so I can avoid having UniCode by default?

Thanks
nsm

Hi,

I get this Extended:UniCode when I save and Import from a sequential File, even though when I am saving I dodn't have the Extended type as :Unicode.

Please advice how to not get this Unicode option by default.
I am having difficulty when I had to disable this option for lot of columns.

Thanks

Hi, Hi I am trying to call KeyMgtGetNextValueConcurrent from Job Sequence and it throws below error. JSEQ015_Load..JobControl (@GenRunID): Routine DSX.KEYMGTGETNEXTVALUECONCURRENT did not finish OK, return code = '3' Also I want to find out if there any disadvantage in using this routine. One of my ...

Hi All,

I am receiving a mainframe file which has COMP , CHAR,COMP-3 type fields. After Importing the copy book I see the data types as CHAR,BINARY , DECIMAl.

If a field is DECIMAL(5,2) I changed it as CHAR(5) field.
I am not sure how to deal with BINARY fields.
Please suggest.

Thanks
nsm.

Hi All, Below are the warnings I am receiving when trying to load a DB2 Table using DB2 API stage from a Dataset. Please suggest me what can cause the below. Below set of warnings are repeating for Table Insert and Update. Finally job aborts with SIGABRT. Thanks nsm. Type: Warning Event: DB2_TbName,...

Hi , I tried 2 different methods. 1)ODBC Enterprise: Get the Timestamp with Microseconds use the left 23 characters and then concatenate "000" to end so, it will have 6 second digits.Passing data to ODBC Enterprise as a varchar worked but the issue with ODBC enterprise is I couldn't pass r...

Hi All, I just started working with Quality Stage. I used Investigate Stage with Word Investigate option. Job ran fine but I couldn't understand the output, Tried looking in the document but I didn't find any explanation refering to output columns. qsInvPattern qsInvCount qsInvPercent I can understa...

Ray,

Where do I see the replies for this post?

Thanks
nsm.

HI, I have a job takes char/varchar type data (unicode enabled) from Sybase to DB2 with no issues. When I tried the other way i.e from DB2 to Sybase it is causing issues. I think its putting null after each character. If I disable Unicode on the target (Sybase) system job worked fine. does anybody k...

you can use unix cut command to get the last nuber for all the files in a separate file then sort in the order you want, then take the last line or the first line depends on the way you sort. As a matter of fact you can use the output of this to the fixed prefix and move the file to different locati...

my requirement is to get currenttimestamp in microseconds -(MINUS)1day.

Please help me in understanding how can I use TimestampFromSecondsSince() function to get what I wanted.

nsm.

Ray,

I tried looking at Julian date functions but couldn't really see anything that does it.
There are functions that gives previous weekday but not date.

I didn't get an idea if there is a way to use Previous week day and get the date out of it.

Thanks
nsm.

Hi,

My requirement is to get CurrentTimeStamp-(Minus)1Day.
I am using CurrentTimestampMS() function to give me CurrentTimeStamp with Microseconds.

In server job/Routine its easier to do this with ICONV/OCONV functions, can somebody help me to do this in parallel job?

Thanks
nsm.

Hello all.

I am having the same issue with sequential file as mouni.
If I use Dataset will it be ok?

I am thinking its ok but let me know if I need to take anything in to consideration like locks or wait time for locks?

Thanks
nsm.