Rick’s Lunch Blog – Genghis Grill

January 24th, 2015

Marinated Steak

Cajun Marinated Chickem

Green Beans

White Onions

Carrots

Salt Blend

Cracked Pepper

Mexican Beans

Peas

Double White Rice

Double Egg

 

SEDAN DRIVERS FOR MAJOR EVENTS NEEDED!

January 19th, 2015

RIDECUT
Is looking for new drivers in your area.
You can set your own hours and make up to $150 a day if

You are…
At least 21 years old, with a driver’s license and auto insurance.

Your Vehicle Is. . .
Any mid-size or full-size 4-door vehicle 2005 or newer in excellent condition.
Earn a $100 bonus if after completing number of rides (usually 10-20)

You have a smart phone, and can work late nights.

http://ridecut.com

DEFINING EXPRESSION IN QUERY MANAGER

October 3rd, 2014

I did not know about the END

EASY_PAY CASE WHEN C.SADPCCSID = 0 THEN ‘N’ ELSE ‘Y’ END

never ending pasta pass

September 24th, 2014

http://neverendingpastapass.com do you have one of these passes?

SQL – INNER vs Left

August 28th, 2014

Select sah.*,ari.*
From prddtalib.slsah sah
Inner join prddtalib.arari ari on ari.UCIHACTID = sah.actid
left join prddtalib.slsad sad on sad.actid=ari.UCITACTID
Where sad.sahnum is null

vs

SELECT * FROM devdtalib/slsah, devdtalib/arari WHERE SLSAH.ACTID =
ARARI.UCIHACTID and NOT EXISTs( SELECT SLSAD.ACTID FROM
DEVDTALIB/SLSAD where ARARI.UCITACTID = SLSAD.ACTID)

UBER COUPON CODES

June 19th, 2014

http://uber-code.com/

UBER COUPON

June 5th, 2014

Free 20$ Über ride. Use this code t3o4m #uberlove

t3o4m

t3o4m

t3o4m

LANSA Template Programming

February 13th, 2014

Here is some template variables to use

@@CLR_LST
Clear a work list

@@CMP_IDX
Compare an index value

@@COMMENT
Add a comment line to the generated RDML code

@@DEC_IDX
Decrement an index value

@@GET_FILS
Get the files to be used in this template

@@GOTO
Pass control to a label

@@IF
Test a condition and pass control to a label

@@INC_IDX
Increment an index value

@@LABEL
A label which is the subject of another command

@@MAK_LSTS
Make a list of selected fields from another list(s)

@@MRG_LSTS
Merge a list(s) with another list(s)

@@QUESTION
Ask a question and receive a reply

@@RTV_FLDS
Retrieve the fields in a file

@@RTV_KEYS
Retrieve the keys of a file

@@RTV_RELN
Retrieve the relationship between two files

@@SET_IDX
Set an index value

FILES:

@@FNAMEnn
File name
A
10

@@FLIBRnn
File library
A
10

@@FVERSnn
File version number
N
15
5

@@FTYPEnn
File type (P=PF, L=LF)
A
1

@@FDESCnn
File description
A
40

@@FBASPnn
Based in physical file name
A
10

@@FRELFnn
Related file name
A
10

@@FRELLnn
Related file library
A
10

@@FRELVnn
Related file version number
N
15
5

@@FRELRnn
Related file relationship (O=1:1, M=1:n)
A
1

@@FRELAnn
Related file access route name
A
10

@@FRELCnn
Related file connection type. The connection types are:

BASE = Base file
DIRBASE = Directly connected to the base file
INDBASE = Indirectly connected to the base file
DETAIL = Detail file
(i.e. 1 : Many related file)
DIRDETL = Directly connected to detail file
INDDETL = Indirectly connected to detail file
A
70

@@FAREAnn
Header or browse area (H=HDR,B=BRW)
A
1

@@TFMX
Maximum file number selected
N
15
5

@@TFMN
Minimum file number selected
N
15
5

FIELDS:

Variable
Description
Type
Len
Dec

1
@@LSTnn
List name – all elements of list
A
Variable

1
@@LSUnn
List name – all elements of list
A
Variable

2
@@LSXnn/yy
List name – first yy elements of list
A
Variable

1
@@LNEnn
Number of elements in list nn
N
2
0

3
@@LELnnxx
Element xx of list nn
A
10

3
@@LATnnxx
Attributes of element xx of list nn
A(7)
10

3
@@LDSnnxx
Description of element xx of list nn
A
40

3
@@LTPnnxx
Type of element xx of list nn (A,P,S)
A
40

Adding New User to LANSA SQL Database LANSADB

January 6th, 2014

Because we have migrated to a new network profile, our access to our LANSA SQL database will now be denied.  These instructions can also be used if inheriting someone’s LANSA install and would like to continue using their existing environment.

 

You need SQL Management studio to add a new login user to SQL, if  not installed you can down load it from Microsoft’s Download center.

 

http://www.microsoft.com/en-us/download/details.aspx?id=7593

 

To add a new user to your SQL database

SQL SERVER 2008

Number 3 Microsoft® SQL Server® 2008 Management Studio Express
ugly2

Install using your pc name/ SQLSERVER as server name
ugly3

Right Click LOGINS and select New
ugly4

This is the ADD screen, use my credentials as a guide.
ugly5

ugly6

ugly7

ugly8

SQL SERVER 2008

 

 

How to use GMAIL POP for Wireless camera

December 25th, 2013

Address: pop.gmail.com

port: 465

gmail address

gmail password

SSL must be yes or checked.

 

For yahoo you must upgrade to plus.